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

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

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