Pinterest Pixel

How to Lock the Excel Pivot Table | A Detailed Tutorial

Sometimes when you are sharing an Excel Pivot Table with your colleagues you do not want the... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

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 🙂

Watch our free training video on How to Lock the Workbook but Not the Slicer in Excel

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

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

How to Lock the Excel Pivot Table | A Detailed Tutorial

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

See also  Pivot Charts & Slicers

How to Lock the Excel Pivot Table | A Detailed Tutorial

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

How to Lock the Excel Pivot Table | A Detailed Tutorial

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

How to Lock the Excel Pivot Table | A Detailed Tutorial

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

How to Lock the Excel Pivot Table | A Detailed Tutorial

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

How to Lock the Excel Pivot Table | A Detailed Tutorial

 

 

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!

Further Learning:

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

See also  Cannot group that selection in an Excel Pivot Table - SOLUTION!
Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!