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 🙂

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 andCheck” the Select Unlocked Cells & Use Pivot Table Reports

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

DOWNLOAD WORKBOOK – UNLOCKED

DOWNLOAD WORKBOOK – LOCKED (Password to unlock: myexcelonline)

Lock the workbook

INSPIRED FROM THIS ONLINE COURSE:

728x90

 

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Related Excel Tutorials