Refresh Pivot in Locked Sheet?
 

I have made a template for other people to use.

They are allowed to refresh a pivot table and do some other
modifications.
However as soon as I lock & protect any part of the sheet, the option
to refresh the pivot disappears.

Is there a way to lock&protect a sheet and allow pivot refreshs?


--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279
View this thread: http://www.excelforum.com/showthread...hreadid=547503

Refresh Pivot in Locked Sheet?
 

Does nobody have a suggestion?


--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279
View this thread: http://www.excelforum.com/showthread...hreadid=547503