+ Reply to Thread
Results 1 to 2 of 2

Lock everything but slicer buttons

  1. #1
    Registered User
    Join Date
    11-02-2011
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question Lock everything but slicer buttons

    Hi,
    I have designed a dashboard for a client in Excel 2010 with Powerpivot.
    It is supposed to provide the client with analytical data when using the slicer buttons to filter relevant data.
    The thing is I don't want the client's end user to mess up the dashboard if they accidently hit anything else than the slicer buttons.
    I have tried to lock the worksheet but that eliminates the possibility to make the sheet refresh the data when the slicer buttons are pressed.
    Does anyone know how to work around this? I have tried the different checkmarks under the 'lock worksheet' section.
    Thanx in advance.

  2. #2
    Forum Contributor
    Join Date
    11-17-2004
    MS-Off Ver
    Office 2016
    Posts
    527

    Re: Lock everything but slicer buttons

    In the Review ribbon under the Protect Sheet option I have the "Use PivotTable reports" and "Edit objects" items selected. This does not prevent the user from selecting the PivotTable ribbon and making changes as this seems to be needed unlocked in order for the Slicer to operate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1