View Single Post
  #1   Report Post  
Saariko
 
Posts: n/a
Default How to lock a worksheet and enable the PivotTable refresh data opt

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