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

Repeat All Item Labels In An Excel Pivot Table Whenever you create a Pivot Table the default layout is in Compact Form, which puts all the data in one column. Many people do not like this layout as you cannot copy and paste the data and do further analysis in another worksheet. The best layout to use is either the Outli...
Sort by Largest or Smallest With Excel Pivot Table... There are countless times when I had my Pivot Table all setup, but I was not really happy with how the data was sorted. The cool thing with Excel Pivot Tables, is it allows me to sort virtually anywhere! Let us start off with this Excel Pivot Table showing the Sum of SALES for...
Group By Month With Excel Pivot Tables Before I was a Pivot Table guru, I had to get individual rows of daily sales and group them into a report showing the monthly sales during the year. Grouping these would take a ton of effort using Formulas: Extracting the month and year from each transactional date; Th...
Microsoft Excel Pivot Tables Online Tutorial Pivot Tables are one of the most powerful features of Microsoft Excel. They allow you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, highlight key information to management and include graphs for your monthly p...