You mean that the worksheet is Protected?
You will likely have to write a macro that Unprotects the Sheet, refreshes
the PivotTable, then Reprotects the sheet. If that's what you are looking for
post back and someone will help you get started.

tj

"Saariko" wrote:

I guess the subject says it all. I have a pivottable I want to lock the
worksheet it's in. but still keep the refresh data button available.

Which of the functions should do it? I tried them all with no success.

Saariko