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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Icon Sets In A Pivot Table An Icon Set is a Conditional Formatting icon/graphic that you can include in your cells or Pivot Tables.The icon will depend on the cell´s value so you can highlight key variances or trends.  There are a few icon sets that you can include, like:DIRECTIONAL (Change in valu...
Insert Subtotals to a Pivot Table When you create a Pivot Table that has multiple fields in the Row Labels, Excel will automatically add a Subtotal to the top of the Group.What about if you want to change the Subtotals to show at the bottom of the Group or take the Subtotals out all together?Well you have...
Classic Pivot Table Layout View For all of you old schoolers out there who used to use the drag and drop Pivot Table option in Excel 2003 or prior, well you still have that option in Excel 2010 and onwards.To activate this option you need to Right Click in your Pivot Table and choose Pivot Table Options. ...
Slicer Styles & Settings There are several different Slicer Styles available for you when you click on an Excel Slicer.These Slicer Styles add color to your Excel workbook to gives it some much needed life!You can also add columns to a Slicer and you can also find more Slicer options by Right...