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

Overview

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

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 🙂

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.

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.

See also  Filter a Pivot Table by Dates

How to Lock the Excel Pivot Table | A Detailed Tutorial

 

 

Download workbook – unlocked Lock-the-workbook-Unlocked.xlsx

Download workbook – lockedLock-the-workbook-Locked.xlsx (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 it
How to Lock the Excel Pivot Table | A Detailed Tutorial | MyExcelOnline How to Lock the Excel Pivot Table | A Detailed Tutorial | MyExcelOnline

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!

Share to...