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


Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

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...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)