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 ***

Watch on YouTube and give it a thumbs up 👍

How to Lock the Excel Pivot Table | A Detailed Tutorial | MyExcelOnline

 

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.

How to Lock the Excel Pivot Table | A Detailed Tutorial | MyExcelOnline

STEP 2: Right-click on a Slicer and select Size & Properties.

How to Lock the Excel Pivot Table | A Detailed Tutorial | MyExcelOnline

STEP 3: In the Format Slicer dialog box, Select Properties, uncheck” the Locked box.

How to Lock the Excel Pivot Table | A Detailed Tutorial | MyExcelOnline

STEP 4: Go to the ribbon menu and select Review > Protect Sheet.

How to Lock the Excel Pivot Table | A Detailed Tutorial | MyExcelOnline

STEP 5: Uncheck” the Select Locked Cells andCheck” the Select Unlocked Cells.

How to Lock the Excel Pivot Table | A Detailed Tutorial | MyExcelOnline

STEP 6: Enter a password (optional) and press OK.

How to Lock the Excel Pivot Table | A Detailed Tutorial | MyExcelOnline

STEP 7: Re-enter the password and press OK.

how to lock pivot table

 

 

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:

728x90

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn