| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect part of pivot table
I want to protect the Page field in a pivot table and have tried leaving the
Page field cells status as locked and unlocking the other fields within the pivot table and then protecting the sheet, but it seems to protect the entire pivot table. My guess is that I will have to run a macro to allow user to unprotect the sheet to refresh the data the protect it again, but thought I would double-check here first. Thanks! -- Thanks! Dee |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect part of pivot table
That's correct. You'll have to unprotect the worksheet so you can
refresh the pivot table. dee wrote: I want to protect the Page field in a pivot table and have tried leaving the Page field cells status as locked and unlocking the other fields within the pivot table and then protecting the sheet, but it seems to protect the entire pivot table. My guess is that I will have to run a macro to allow user to unprotect the sheet to refresh the data the protect it again, but thought I would double-check here first. Thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| protect parts of a pivot table | Excel Worksheet Functions | |||
| Protect Pivot Table Individual Results | Setting up and Configuration of Excel | |||
| DSUM when database is part of a pivot table | Excel Worksheet Functions | |||
| Pivot table with protect workbook | Excel Discussion (Misc queries) | |||
| Hide part of Pivot Table | Excel Worksheet Functions | |||
Linear Mode
