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.