Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


  #3   Report Post  
Junior Member
 
Posts: 10
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
enable automatic refresh Chris Excel Discussion (Misc queries) 4 January 12th 08 04:43 PM
How can I 'Enable Automatic Refresh' for Query Refresh by default Anand Deshpande Setting up and Configuration of Excel 0 December 10th 06 04:47 AM
Enable Automatic Refresh Terri Excel Worksheet Functions 1 August 8th 05 11:26 PM
Query Refresh-Enable Automatic Refresh Dialogue Box Terri Excel Discussion (Misc queries) 0 May 6th 05 08:21 PM
How to lock a worksheet and enable the PivotTable refresh data opt Saariko Excel Worksheet Functions 3 October 31st 04 03:02 PM


All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"