Protect Charts and Slicers in Excel for the Web
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.
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.
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.
Select the plus button beside the sheet tabs to create a new worksheet, then rename it to something such as Dashboard.
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.
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.
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.
Configure object protection in desktop Excel
Use desktop Excel when preventing users from moving charts and slicers is more important than editing the workbook entirely in a browser.
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. Open the workbook in WPS Spreadsheets: Launch WPS Office, select Spreadsheets, choose Open, and load the Microsoft Excel .xlsx workbook.
- 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. 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.

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.




