Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I use pivot tables in my spreadsheet.
When I protect the sheets to prevent changes to locked cells, the pivot tables wont allow data refresh?! Even when I check all the boxes when protecting a sheet - including the pivot tables check box, still the pivot tables cannot be activated. The pivot table cells are all unlocked as is the data it reads from. Can anyone help me? Tahnks, Roger |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
protected work sheet | Excel Discussion (Misc queries) | |||
Pivot tables and work sheets | Excel Worksheet Functions | |||
Protected work sheet | Excel Discussion (Misc queries) | |||
If I have a work sheet protected and try to run a macro to hide rows or columns it won't work. Correct? | Excel Programming | |||
Macro protected work sheet | Excel Programming |