Excel Table not expanding when worksheet is protected

[Stanman]

Hi,
With cell protection enabled, sheet with a excel table in it will not expand but if I take the protection off it will, is there anyway round this? I have the cells that can be edited unlocked and formula cells protected.

If it can't be done any other way I can protect the cell formula's?

Thanks

 

[Fluff]

That is one of the drawbacks of tables on a protected sheet. You can either protect the sheet & loose some of the functionality, or keep the functionality but not protect the sheet.
There is no half-way house.