| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh Pivot in Locked Sheet?
I have made a template for other people to use. They are allowed to refresh a pivot table and do some other modifications. However as soon as I lock & protect any part of the sheet, the option to refresh the pivot disappears. Is there a way to lock&protect a sheet and allow pivot refreshs? -- Dark_Templar ------------------------------------------------------------------------ Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279 View this thread: http://www.excelforum.com/showthread...hreadid=547503 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Refresh Pivot in Locked Sheet?
Does nobody have a suggestion? -- Dark_Templar ------------------------------------------------------------------------ Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279 View this thread: http://www.excelforum.com/showthread...hreadid=547503 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refresh scenario information in a pivot table | Excel Discussion (Misc queries) | |||
| Pivot table Data refresh | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| Pivot table refresh | Excel Worksheet Functions | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Linear Mode
