PivotTable question

J

joone

Is it possible to Click on "Refresh Data" on a Pivot
Table if the sheet is protected?
It is not letting me at this time and wondering if
there's anything I can do to make it happen.

thnx
 
N

Nick Hodge

No, you cannot refresh the data when the sheet is protected. The only way
is to un-protect it.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top