Refresh Pivot Table when Sheet is PW Procted
 

is it possible to refresh a pivot table in a protected worksheet?

Refresh Pivot Table when Sheet is PW Procted
 

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.

Mayte wrote:
is it possible to refresh a pivot table in a protected worksheet?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html