Refresh pivot table on protected sheet

R

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.
 
G

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.
Click to expand...

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.
 
D

Debra Dalgleish

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

GTVT06

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

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