Cannot Refresh Pivot Table In Protected Sheet

[tomohawk]

I have a sheet with a Pivot Table, which references a data table in another sheet.



The sheet with the Pivot Table is protected, BUT, the cells used by the Pivot Table are NOT protected.

When I try and right-click in order to Refresh, that option is unavailable.

I activated the option in the Pivot Table to refresh on file open.

Now, when I open the file, I get a message "Cannot edit PivotTable on protected sheet"

Tommy

[Pecoflyer]

Perhaps Refresh an Excel Pivot Table on a Protected Sheet – Excel Pivot Tables

[tomohawk]

Thanks Pecoflyer

[Pecoflyer]

You're welcome and thanks for the rep