| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
| Pivot Table Use When Sheet is Protected | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Threaded Mode
