How to Let View-Only Excel Users Interact with PivotTable Slicers
Question details
Protect an Excel workbook so view-only users can still interact with PivotTable slicers without editing other content.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user is sharing a protected Excel workbook and wants recipients to filter a PivotTable with slicers without being able to edit other cells or workbook structure.
- Observed behavior
- After normal worksheet protection, slicers may be locked or PivotTable interaction is blocked unless the correct protection settings are applied.
Open the workbook in Excel and confirm that the PivotTable and slicers are already created. Make sure you have permission to change worksheet protection, workbook protection, and sharing settings.
Use Worksheet Protection Settings and Unlock Slicers
Use this solution when you need to share a protected Excel workbook but still let view-only users click PivotTable slicers.
In Microsoft Excel, sheet protection normally locks slicers unless you explicitly unlock them and allow PivotTable and PivotChart use. The exact ribbon labels may vary slightly by Excel version.
Right-click each slicer, open Size and Properties or Format Slicer, go to Properties, and clear the Locked check box.
Go to Review > Protect Workbook, then enable Protect Workbook Structure to prevent adding, moving, or deleting sheets.
Select the sheet containing the slicers, go to Review > Protect Sheet, check Use PivotTable and PivotChart in the Allow all users of this worksheet to list, optionally set a password, and click OK.
Upload the file to SharePoint, OneDrive, or another shared location and grant recipients view or edit permissions according to your sharing policy.
Open the workbook from the shared location as a viewer, click each slicer to confirm it filters the PivotTable, and verify that protected cells cannot be edited.

Switch to WPS Office for Excel-Compatible Slicers and Protection
Microsoft Excel controls some sharing and protection behavior through SharePoint or OneDrive. WPS Office is a free, lightweight alternative that opens and saves .xlsx workbooks with a familiar interface, so you can manage spreadsheet protection and PivotTable workflows without the cost or complexity.

Frequently Asked Questions
Why are slicers locked after I protect an Excel worksheet?
Worksheet protection locks all locked objects by default. Before protecting, right-click each slicer and clear the Locked check box under Size and Properties > Properties, then allow Use PivotTable and PivotChart in the Protect Sheet dialog.
Can I password-protect the sheet and still allow slicer use?
Yes. In Review > Protect Sheet, check Use PivotTable and PivotChart, set a password, and make sure the slicers are unlocked.
Does this work in Excel for the web or SharePoint?
Slicer interaction may be supported in Excel for the web, but behavior depends on the file sharing permissions and Excel version. Test with the target account before sharing broadly.
Do users need edit permissions to use slicers?
No. Viewers can use slicers if sheet protection allows PivotTable and PivotChart, each slicer is unlocked, and the workbook is shared with the appropriate permission.
What is the difference between workbook structure protection and worksheet protection?
Workbook structure protection prevents adding, moving, or deleting sheets. Worksheet protection restricts editing within the sheet. For slicers, configure both: protect the workbook structure and allow PivotTable use in the Protect Sheet settings.




