View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default 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