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.