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

Share on Google+

Google+

Related Posts

Pivot Table Conditional Formatting Inserting a Pivot Table is very easy to do in Microsoft Excel: Inserting a Pivot Table Adding some Conditional Formats to the Pivot Table allows a user to highlight key data in a split second. See how easy it is to add some color to your analysis. DOWNLOAD WORKBOOK ...
Group Dates with a Pivot Table Grouping Dates is very easy with a Pivot Table.  All you have to do is Right Click on your Date values (which are either in the Row or Column Labels of your Pivot Table), then choose the Group option.  From the dialogue box you can choose to Group by Days, Months, Quarters or Yea...
Pivot Table Report Layouts Pivot Tables have three different layouts that you can choose from: Compact, Outline and Tabular Form. You can choose from each layout by clicking in the Pivot Table and going to PivotTable Tools > Design > Report Layouts They each have their advantages and disadvanta...
Group Sales with a Pivot Table A Pivot Table allows you to Group your transactional sales values by any range that you want.  You can then summarize each sales group and see the total sales and the number of transactions that they have produced.  This is useful for pricing analysis. DOWNLOAD WORKBOOK ...