cannot edit pivot table on protected sheet

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
 
S

Shane Devenshire

Hi,

Here are some options:

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