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