cannot edit pivot table on protected sheet

  • Thread starter Thread starter ian c
  • Start date Start date
I

ian c

this message box comes up every time i open an excel workbook "cannot edit a
pivot table in a protected workbook" how can i stop it
 
Hi,

Here are some options:

1. Turn off protection
2. Unprotect the file and choose PivotTable, Table Options, and uncheck
Refresh on open.
 
Back
Top