I ian c Dec 7, 2008 #1 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
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 Dec 9, 2008 #2 Hi, Here are some options: 1. Turn off protection 2. Unprotect the file and choose PivotTable, Table Options, and uncheck Refresh on open.
Hi, Here are some options: 1. Turn off protection 2. Unprotect the file and choose PivotTable, Table Options, and uncheck Refresh on open.