Pivot Table Issues

How to Let View-Only Excel Users Interact with PivotTable Slicers

Muhammad TalhaMuhammad Talha Nov 13, 2026 869 views

Question details

Protect an Excel workbook so view-only users can still interact with PivotTable slicers without editing other content.

How to Let View-Only Excel Users Interact with PivotTable Slicers
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.
Before you start

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.

Solution 1Recommended

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.

1
Unlock each slicer

Right-click each slicer, open Size and Properties or Format Slicer, go to Properties, and clear the Locked check box.

2
Protect the workbook structure

Go to Review > Protect Workbook, then enable Protect Workbook Structure to prevent adding, moving, or deleting sheets.

3
Protect the worksheet with PivotTable use enabled

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.

4
Share the workbook with suitable permissions

Upload the file to SharePoint, OneDrive, or another shared location and grant recipients view or edit permissions according to your sharing policy.

5
Test as a view-only user

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.

Use Worksheet Protection Settings and Unlock Slicers
Test in the target Excel version: Slicer behavior may differ depending on the Excel version and sharing location. Always test with a view-only account before distributing the workbook.
Free Microsoft Office alternative

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.

Opens and saves .xlsx files with PivotTable and slicer compatibilityFamiliar ribbon and protection controls make it easy to switch from ExcelFree, lightweight suite for Windows, macOS, Android, iOS, and LinuxNo subscription required for viewing and editing everyday workbooks
microsoft office alternative - wps office

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.