View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
michaelnol michaelnol is offline
external usenet poster
 
Posts: 4
Default 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