Use Pivot Tables and Slicers on Protected Worksheets

Add to Favorites
Author: | Edits: don

How to allow the use of a Pivot Table and its Slicer on a worksheet that is protected.

This allows you to keep your data safe from the user while allowing them to still analyze the data, expand and collapse rows, and filter though all of the data in the Pivot Table.

This tip works if the worksheet is protected with or without a password and it should not interfere with any other part of the spreadsheet.

Additional Resources

Password Protect Worksheets (msft)

Pivot Tables (msft)


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Link Worksheet Form Controls with Cells on Protected Worksheets without VBA Macros in Excel
Tutorial: Simple method to use Excel Form Controls and ActiveX Controls and link them to cells on p...
Slicer Power Analysis in Excel - Pivot Tables + Pivot Charts + Tables + Slicers
Tutorial: Powerful Excel data visualization and analysis that uses a combination of techniques, whi...
List Slicer Selections in a Cell in Excel
Tutorial: How to list all slicer selections for a Pivot Table in a single cell in Excel. This allow...
Remove Deleted Items from Slicers & Pivot Tables
Tutorial: How to remove items from a Slicer that are not actually in the data set that the Slicer f...
Pivot Chart Formatting Copy Trick in Excel - Excel Quickie
Tutorial: Easily copy Pivot Chart formatting from one Pivot Chart to another Pivot Chart in Excel. ...
3 Slicer Tricks for Pivot Tables in Excel
Tutorial: 3 ways to better use Slicers for Pivot Tables in Excel. These tips will show you how to a...