Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Enable Slicer Data Refresh in Locked S/S
I have a spreadsheet connected to an anlysis cube that is updated/
changed using slicers. I want to be able to lock the spreadsheet so no editing etc can take place on the s/s but still have the slicers remain active and working I have looked high and low to a solution to this problem with no luck, so any help would be useful, thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Enable Slicer Data Refresh in Locked S/S
michaelnol wrote :
I have a spreadsheet connected to an anlysis cube that is updated/ changed using slicers. I want to be able to lock the spreadsheet so no editing etc can take place on the s/s but still have the slicers remain active and working I have looked high and low to a solution to this problem with no luck, so any help would be useful, thanks You need to check your other posting in the other group you originally posted to. Also, it's better to 'cross-post' rather than post to multiple groups individually because cross-posted replies are updated in all groups cross-posted to. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#3
|
|||
|
|||
I want to be able to lock the spreadsheet so
no editing etc can take place on the s/s but still have the slicers remain active and working. ________ memory foam mattress | adjustable mattresses | memory pillow Last edited by mickrio : February 13th 12 at 10:12 AM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enable automatic refresh | Excel Discussion (Misc queries) | |||
How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
Enable Automatic Refresh | Excel Worksheet Functions | |||
Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
How to lock a worksheet and enable the PivotTable refresh data opt | Excel Worksheet Functions |