Cannot Refresh Pivot Table In Protected Sheet

		Microsoft Office Forums > Microsoft Excel > Excel
Cannot Refresh Pivot Table In Protected Sheet

FAQ

Thread Tools

Display Modes

01-04-2025, 06:31 AM

tomohawk

Windows 10 Cannot Refresh Pivot Table In Protected Sheet

Office 2019

Advanced Beginner

Join Date: Sep 2020

Location: Dublin

Posts: 60

Cannot Refresh Pivot Table In Protected Sheet

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto-refresh pivot table without losing undo buffer	Peterson	Excel Programming	0	03-25-2020 06:56 PM
Need Help Macro That Uses Pivot Table to Create New Sheet	Bob123456789	Excel Programming	13	03-14-2017 01:25 PM
Autoexpand Table on Protected Sheet	Catalin.B	Excel	0	09-07-2014 07:03 AM
Auto Refresh Pivot Table on Timer	bremen22	Excel	2	10-01-2013 01:00 AM
Pivot Table Refresh	tpcervelo	Excel	0	09-14-2010 06:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:48 PM.