Pivot Table - problem with protected sheets
I have created a worksheet for a client to use and want to protect it to stop accidental messing up. It contains a pivot table which the client must refresh when certain new data is added but it appears to me that if I protect the sheet this does not allow me to make refreshing the pivot table an exception to the the protection, which makes the pivot table redundant.
Help would be much appreciated.


VBA will work