Office Settings & Configuration

Protect Charts and Slicers in Excel for the Web

Maira MehtabMaira Mehtab Nov 12, 2026 868 views

Question details

The user needs to limit changes to charts and slicers in an Excel workbook opened in a web browser.

Product
Microsoft Excel for the web
Device & OS
not provided
Scenario
A workbook contains charts and slicers that should remain usable but should not be moved or rearranged by other users.
Observed behavior
Protected charts and slicers may still be movable in Excel for the web because the web version does not expose all object-position protection settings available in desktop Excel.
Before you start

Identify which charts and slicers must remain interactive and which objects should be locked in place. If precise object protection is required, confirm that the desktop version of Excel is available for configuring the workbook.

Solution 1Recommended

Place charts and slicers on a separate protected worksheet

Use this approach when users need to view charts and interact with slicers while minimizing changes to the rest of the workbook.

Excel for the web does not always provide the same protection controls as the desktop application. A separate dashboard sheet makes the protected objects easier to manage, but users may still be able to move objects in the web version if object-position protection is unavailable.

1
Create a dashboard worksheet

Select the plus button beside the sheet tabs to create a new worksheet, then rename it to something such as Dashboard.

2
Move the workbook objects

On the original worksheet, select each chart and slicer, use Cut from the Home tab or the right-click menu, select the Dashboard sheet, and use Paste.

3
Protect the dashboard sheet

Open the Review tab, select Protect Sheet, set a password if required, and choose the permissions that allow users to select or use slicers where those options are available.

4
Test the protected workbook

Select a slicer and test its filtering behavior, then try to drag a chart or slicer. If the object can still move, open the workbook in desktop Excel for stronger object-level protection.

Web protection limitation: Excel for the web may still allow charts or slicers to be moved even after sheet protection is enabled. This is a limitation of the web version rather than a failure of the worksheet setup.
Free Microsoft Office alternative

Use WPS Office for Lightweight Desktop Workbook Protection

WPS Office provides a free, lightweight desktop alternative for opening and managing Excel-compatible workbooks. Its familiar spreadsheet interface supports common worksheet protection workflows and makes it easy to review charts, slicers, and locked workbook areas before sharing a file.

  1. 1. Open the workbook in WPS Spreadsheets: Launch WPS Office, select Spreadsheets, choose Open, and load the Microsoft Excel .xlsx workbook.
  2. 2. Review the dashboard objects: Select the worksheet containing the charts and slicers, check their placement, and confirm that the dashboard layout is ready to share.
  3. 3. Apply available sheet protection: Open the Review tab and use the sheet protection controls available in WPS Spreadsheets to restrict edits to protected worksheet areas.
Review and organize charts and dashboard objects in a lightweight desktop spreadsheet editor.Use a familiar Office-style interface to manage worksheet protection settings.Open and save Microsoft Excel .xlsx workbooks with broad format compatibility.Reduce reliance on browser-based editing when workbook object positioning must be checked locally.
microsoft office alternative - wps office

Frequently Asked Questions

Why can users still move protected charts in Excel for the web?

Excel for the web does not expose every object-position protection setting supported by desktop Excel. Sheet protection may limit cell edits while still allowing some chart or slicer movement.

Can I let users use slicers without allowing them to move them?

Place the slicers on a separate worksheet, select Review > Protect Sheet, and enable the available options for selecting or using slicers. Test the workbook in the target browser because web behavior can vary.

What is the best way to prevent charts and slicers from being rearranged?

Open the workbook in desktop Excel, select each object, confirm its Locked setting under Format Selection, and use Review > Protect Sheet with Edit objects disabled.

Will protecting the worksheet stop slicers from filtering data?

Not always. Slicer interaction depends on the protection permissions and Excel version. After protecting the sheet, test the slicer and adjust the available permissions if filtering is blocked.