Refresh pivot table on protected sheet

[richzip]

Is there any way to allow a pivot table to refresh with a protected sheet? I
have the cells containing the pivot table "unprotected", but when the sheet
is protected it still won't refresh. The "refresh data" option is grayed out.

 

[GTVT06]

Is there any way to allow a pivot table to refresh with a protected sheet? I
have the cells containing the pivot table "unprotected", but when the sheet
is protected it still won't refresh.  The "refresh data" option is grayed out.

When you protect your sheet, place a check mark next to "Use Pivot
Table Reports" If your protecting the sheet in VBE or in a macro you
would add , AllowUsingPivotTables:=True to the protection code.

 

[Debra Dalgleish]

No, you will have to unprotect the sheet, either manually or
programmatically, before you can refresh the pivot table.

 

[GTVT06]

No, you will have to unprotect the sheet, either manually or
programmatically, before you can refresh the pivot table.

Sorry about that Debra is right. It wont refresh unless the sheet is
unprotected.