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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refreshing Pivot Table on a protected spreadsheet tab 1
Pivot Table update 8
Macro for auto refresh 1
Pivot Table - Changes 5
Refresh Pivot table data in Protected sheet 3
Refresh order when refreshing all in a workbook 1
Refreshing a pivot table 1
Pivot Table Refresh not working properly 1

Top