protected worksheet

[SAM]

Is there anyway to program excel to auto refresh the pivot table in a
protected worksheet?

I need to a work around to refresh data even when it is protected.

[raypayette]

You would have to have a macro that unprotects it temporarily, updates it and reprotects it again. Using the macro recorder will do this easily!