Excel: Protect a Sheet but Keep Slicers Usable for Users

How-to basics · Updated November 21, 2026

Yes. In Excel for Microsoft 365 on Windows, unlock the slicer before protecting the worksheet, then protect the sheet without granting permission to edit objects. For a slicer connected to a PivotTable, also allow Use PivotTable reports in the protection options when needed; test the finished sheet because the exact permissions depend on what the slicer controls.

Why sheet protection can stop a slicer

A slicer is a clickable control placed on a worksheet, not merely a display of filter results. Excel’s worksheet protection can block interaction with locked objects, and a slicer is locked by default in many workbooks. As a result, a user may see the slicer but be unable to click its buttons. The sheet can still look normal, which makes the cause easy to mistake for a broken filter or an unresponsive workbook.

There are two separate permissions to consider. The slicer’s own Locked setting determines whether it can be used while the sheet is protected. The protection dialog’s permissions determine which worksheet actions are permitted, including whether users can interact with PivotTable reports. Unlocking the slicer does not remove worksheet protection or unlock the cells in the report.

Protection is intended to prevent accidental changes, not to provide strong confidentiality. Users may still be able to view workbook contents, copy information they can access, or work around protection in other ways. Do not use sheet protection as a substitute for file encryption, access controls, or careful sharing settings.

Set up a protected sheet with a usable slicer

On Windows, make these changes while the sheet is unprotected. If the workbook already has protection enabled, choose Review > Unprotect Sheet first and provide the password if prompted. Then configure the slicer and protect the sheet again:

  1. Select the slicer. Right-click it and choose Size and Properties. In the Format Slicer pane, expand Properties and clear Locked. Depending on the Excel build and pane layout, you may need to expand Size & Properties before the Properties choices appear.
  2. If this slicer filters a PivotTable, note which worksheet contains the PivotTable and which sheet contains the slicer. If both sheets are protected, review the permissions on both; allowing the slicer object on the dashboard does not automatically grant permissions on another protected sheet.
  3. Choose Review > Protect Sheet. Set a password if appropriate, then select only the actions users should be allowed to perform. For a PivotTable-connected slicer, select Use PivotTable reports where available and required for the intended filtering behavior.
  4. Leave Edit objects cleared if users should not move, resize, or otherwise edit drawing objects. The slicer itself should be unlocked, so users can click its buttons without receiving broad permission to edit objects.
  5. Confirm the protection settings, then click several slicer buttons and test clearing the filter. Also check that users cannot edit cells or move the slicer when those actions are meant to remain restricted.

For a slicer connected to an Excel Table rather than a PivotTable, the Use PivotTable reports option does not apply. Unlock the slicer and protect the sheet with the other permissions set to suit the worksheet. If it still cannot filter, check that the slicer actually belongs to that table and that the sheet was protected after the slicer’s Locked setting was changed.

Choose permissions without opening up the worksheet

The Protect Sheet dialog offers multiple permissions, and selecting more than necessary can defeat the purpose of protection. For a dashboard where users should only filter data, keep cell editing, formatting, inserting, deleting, sorting, and object editing disabled unless the workflow requires them. A slicer’s ability to filter is different from permission to change the worksheet’s layout.

  • Use PivotTable reports: Relevant to PivotTable reports and potentially necessary for a PivotTable slicer to work on a protected sheet. It permits report interaction, so test what users can change rather than assuming it allows only one narrow action.
  • Edit objects: This is broader than using an unlocked slicer. It can allow changes to drawing objects such as shapes, charts, and controls. Avoid enabling it just to make a slicer clickable.
  • Select locked or unlocked cells: These options govern cell selection, not whether a slicer filters correctly. Choose them based on how people should navigate the sheet.
  • Use AutoFilter: This permission concerns worksheet AutoFilter controls; it is not a universal replacement for enabling PivotTable report interaction.

Permission labels can be confusing because a slicer looks like a button but filters a data object behind the scenes. Keep the slicer unlocked, grant only the report permission needed for PivotTable use, and verify the result with a non-owner workflow if possible. Do not grant Edit objects as a shortcut unless allowing users to alter objects is acceptable.

Table slicers and PivotTable slicers are different

Excel supports slicers for both formatted Tables and PivotTables. A Table slicer filters rows in the Table itself. A PivotTable slicer filters a PivotTable, and it may also be connected to other PivotTables that share a compatible data source or PivotTable cache. The controls can look alike, but the underlying feature and relevant sheet-protection permissions differ.

For example, a sales dashboard might have a Table containing transaction rows and a slicer for Region. Unlocking that slicer lets a user filter the Table while the rest of the sheet remains protected. A second dashboard might use a PivotTable summarizing sales by month and a Region slicer. That setup may require the Use PivotTable reports permission on the protected sheet containing the PivotTable, in addition to unlocking the slicer object.

If a slicer controls multiple PivotTables on different sheets, check each affected sheet. A protected destination sheet can still prevent an operation even when the slicer’s own sheet allows clicks. Similarly, hiding a PivotTable sheet does not make its protection settings irrelevant. Test all connected reports after changing protection.

What protection does and does not protect

Worksheet protection is useful for preventing accidental edits to formulas, labels, and layout. It is not the same as protecting the workbook’s structure, and neither feature should be treated as a guarantee that data is secret. Protecting a sheet does not encrypt its contents. If a workbook contains sensitive information, use appropriate file-level security and share it only with people who should have access.

Workbook-structure protection is a separate setting, found under Review > Protect Workbook. It restricts certain changes to the workbook’s sheet structure, such as moving, deleting, or renaming sheets. It does not unlock a slicer or replace the permissions needed on a protected worksheet. In some workbooks both kinds of protection are used, but they solve different problems.

It is also useful to distinguish filtering from editing source data. A user may be allowed to change a slicer selection while still being unable to change the underlying cells. However, if a report permission enables broader PivotTable interaction than intended, test the available actions before distributing the file. For tightly controlled reports, consider whether users should receive a read-only copy or access to a separate reporting interface instead.

Common problems and how to diagnose them

  • The slicer is visible but clicks do nothing. Unprotect the sheet and inspect the slicer’s Locked property. Clear it, protect the sheet again, and test. For a PivotTable slicer, review the Use PivotTable reports setting as well.
  • The slicer works on one sheet but not another. Check protection on every sheet containing a connected PivotTable. A slicer can control more than one report, and each protected sheet can impose its own restrictions.
  • The slicer filters one report but not another. The reports may not share a compatible connection or PivotTable cache, or the slicer may not be connected to both. For PivotTables, select the slicer and look for Report Connections or PivotTable Connections on the Slicer tab. The exact label can vary by Excel version and context.
  • The slicer can be moved or resized. Check whether Edit objects was enabled. Clear it if users should only use the control, and confirm the slicer is unlocked so it remains clickable.
  • The option is unavailable or protection behaves unexpectedly. Confirm that the sheet is unprotected while changing the slicer property, and that the slicer is the selected object rather than a cell. Save, close, and reopen a copy to retest if the workbook has complex connections or shared editing features.

When troubleshooting, change one setting at a time and test with a copy of the workbook. That makes it easier to identify whether the issue comes from the slicer object, PivotTable permissions, a connection, or an additional protection setting.

Windows, Mac, and Excel for the web

The steps above are written for Excel for Microsoft 365 on Windows. Excel for Mac also supports worksheet protection and slicers, but ribbon names, pane placement, and some protection options can differ by version. Use the sheet-protection controls on the Review tab and inspect the slicer’s formatting or properties pane for its Locked setting. If a needed PivotTable permission is absent or behaves differently, test the workbook in the Windows desktop version before relying on that workflow.

Excel for the web has a more limited feature set for some workbook editing and protection tasks. Depending on the workbook and current web capabilities, you may be able to interact with an existing slicer but not configure all of its object properties or protection options there. Set up and validate the protected workbook in the desktop app, then confirm that the intended users can filter it in their actual version of Excel. Do not assume that a result tested only in one platform will behave identically in another.

Frequently Asked Questions

Can I use a slicer on a protected Excel sheet?
Yes. Clear the slicer’s Locked setting before protecting the sheet. If the slicer controls a PivotTable, also allow Use PivotTable reports when that permission is needed, then test the protected workbook.

Do I have to check Edit objects to use a slicer?
Usually, no. Unlock the slicer itself and leave Edit objects cleared if users should not move or alter worksheet objects. Enabling that permission gives broader object-editing access than simply allowing slicer clicks.

Does the PivotTable permission apply to a slicer for an Excel Table?
No. Use PivotTable reports is for PivotTable-related interaction. A Table slicer filters the Table, so focus on its Locked setting and the sheet-protection options relevant to the rest of the worksheet.

Can a slicer filter PivotTables on other protected sheets?
It can, if the reports are connected and the protection settings permit the required interaction. Check the slicer’s report connections and the protection on every sheet containing a PivotTable it should control.

Does protecting the sheet hide or secure the filtered data?
No. Worksheet protection is mainly an editing restriction, not encryption or a confidentiality control. Use appropriate file security and sharing permissions when data must be kept private.

A practical way to finish

For a reliable handoff, configure the slicer while the sheet is unprotected, clear its Locked setting, and protect the sheet with only the necessary permissions. For PivotTable reports, include the report permission if required and check every connected protected sheet. Finally, test filtering, clearing the filter, cell editing, and object movement. That small review confirms that users can explore the data without receiving unnecessary access to the worksheet’s formulas or layout.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.