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.

 

Comments
There are 4 comments. Login or register to view them.

VBA will work

leestevens |

Thoughts on password

paulwakefield1 |

Many thanks

StanleyW |

a little help?

scionthelast |