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 learn how to lock 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 on how to lock pivot table with free downloadable Excel workbook to practice ***
Here is a step-by-step tutorial on How to Lock 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: In the Format Slicer dialog box, Select Properties, “uncheck” the Locked box.
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.
STEP 6: Enter a password (optional) and press OK.
STEP 7: Re-enter the password and press OK.
DOWNLOAD WORKBOOK – UNLOCKED
DOWNLOAD WORKBOOK – LOCKED (Password to unlock: myexcelonline)
This completes the tutorial on how to lock pivot table format and how to lock slicers in Excel!
INSPIRED FROM THIS ONLINE COURSE: