Refresh pivot table on protected sheet

  • Thread starter Thread starter richzip
  • Start date Start date
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.
 
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.
 
No, you will have to unprotect the sheet, either manually or
programmatically, before you can refresh the pivot table.
 
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
Refresh Pivot table data in Protected sheet 3
Pivot Table update 8
Refresh Pivot table data in protect sheet 2
Protect part of pivot table 1
Macro for auto refresh 1
Refresh order when refreshing all in a workbook 1
Refresh Pivot in Locked Sheet? 1

Back
Top