How do you unlock a pivot table on a protected excel sheet?
 

I have a protected worksheet with only input cells unlocked. A pivot table
was created to analyze data, however when I protect the worksheet it does not
allow the ordinary user the ability to refresh the pivot table data?

Is it possible to protect the worksheet and still allow other users to
refresh the pivot table?

You can do it with code by putting a button on the sheet to unprotect,
refresh and reprotect, something like
Sub Refresh()
ActiveSheet.Unprotect ("Password")
ActiveSheet.PivotTables("PivotTable1").PivotCache. Refresh
ActiveSheet.Protect ("Password")
End Sub
Please post back if you're unfamiliar with VBA code,
Regards,
Alan.
" wrote
in message ...
I have a protected worksheet with only input cells unlocked. A pivot table
was created to analyze data, however when I protect the worksheet it does
not
allow the ordinary user the ability to refresh the pivot table data?

Is it possible to protect the worksheet and still allow other users to
refresh the pivot table?

I can follow the code and if it is correct in syntax accomplish it. However
it has been a long time since I done much programming.

"Alan" wrote:

You can do it with code by putting a button on the sheet to unprotect,
refresh and reprotect, something like
Sub Refresh()
ActiveSheet.Unprotect ("Password")
ActiveSheet.PivotTables("PivotTable1").PivotCache. Refresh
ActiveSheet.Protect ("Password")
End Sub
Please post back if you're unfamiliar with VBA code,
Regards,
Alan.
" wrote
in message ...
I have a protected worksheet with only input cells unlocked. A pivot table
was created to analyze data, however when I protect the worksheet it does
not
allow the ordinary user the ability to refresh the pivot table data?

Is it possible to protect the worksheet and still allow other users to
refresh the pivot table?