PivotTable question

  • Thread starter Thread starter joone
  • Start date Start date
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
 
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
(e-mail address removed)
 
Back
Top