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

G

Guest

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?
 
A

Alan

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refresh Pivot Table when Sheet is PW Procted 1
Password protect cells PivotTable & allow the Pivot Table to refre 2
Pivot table data source 1
Pivot Table 2
Pivot Table Refresh Not Updating Drop Down List 1
Workbook pivot table design function 6
Adding button to worksheet to refresh pivot table data 1
why do I lose cell format in a pivot table? 1

Top