| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to partially protect a pivot table based worksheet
Hi, I need to partially protect a pivot table based worksheet but to allow
users to select some of pivot table fields but not others. How can I do this. I have tried protecting using the lock cells/elements feaure to allow users to use pivot table reports but then I get a message saying it cannot perform the command because it needs a data refresh and I need to unlock the worksheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PROTECT PIVOT TABLE | Excel Discussion (Misc queries) | |||
| Pivot Table Field List Is Only Partially Displayed | Excel Discussion (Misc queries) | |||
| protect parts of a pivot table | Excel Worksheet Functions | |||
| Pivot table with protect workbook | Excel Discussion (Misc queries) | |||
| Partially protect a cell? | Excel Worksheet Functions | |||
Threaded Mode
