protected worksheet
 

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.

protected worksheet
 

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

--
raypayett

-----------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...fo&userid=2956
View this thread: http://www.excelforum.com/showthread.php?threadid=57048