is it possible to refresh a pivot table in a protected worksheet?
D Debra Dalgleish Jun 13, 2008 #2 No, you'll have to unprotect the worksheet to refresh the pivot table. You could record a macro as you unprotect, refresh and protect, then run that macro as required.
No, you'll have to unprotect the worksheet to refresh the pivot table. You could record a macro as you unprotect, refresh and protect, then run that macro as required.
