you can record a macro as you unprotect the sheet, refresh, then reprotect.
Then, add a "Refresh" button to the worksheet, and assign that macro to
the button.


Rob Coldwell wrote:
I have a work book which has a pivot table integrated as a summary page. I
need to allow the end user to update the pivot table with their changes but
not allow them to be able to change/modify/update the pivot table it self?

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html