Enable Slicer Data Refresh in Locked S/S

[michaelnol]

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

 

[GS]

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.