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.