Refresh pivot table on protected sheet
 

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.

Refresh pivot table on protected sheet
 

On Jan 18, 10:46*am, richzip
wrote:
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.

Refresh pivot table on protected sheet
 

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


richzip wrote:
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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Refresh pivot table on protected sheet
 

On Jan 18, 2:01*pm, Debra Dalgleish wrote:
No, you will have to unprotect the sheet, either manually or
programmatically, before you can refresh the pivot table.

richzip wrote:
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.

--
Debra Dalgleish
Contextureshttp://www.contextures.com/tiptech.html

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