Sometimes when you are sharing an Excel Pivot Table with your colleagues you do not want the other user(s) to mess with your Pivot Table layout and format.
What you can do is lock the Pivot Table and only allow the user(s) to select the Slicers, making your report interactive and secure from Excel novices like your boss 🙂
Did you know you could also Lock the Workbook but Not the Slicer in Excel?
*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***
Here is how you can lock the Pivot Table but not the Slicers:
STEP 1: Click on a Slicer, hold the CTRL key and select the other Slicers
STEP 2: Right click on a Slicer and select Size & Properties
STEP 3: Under Properties, “uncheck” the Locked box and press Close
STEP 4: Go to the ribbon menu and select Review > Protect Sheet
STEP 5: “Uncheck” the Select Locked Cells and “Check” the Select Unlocked Cells & Use Pivot Table Reports
STEP 6: Enter a password (optional) and press OK
DOWNLOAD WORKBOOK – LOCKED (Password to unlock: myexcelonline)
INSPIRED FROM THIS ONLINE COURSE: