To unlock an Excel slicer, first unprotect its worksheet if necessary, then right-click the slicer and choose Size and Properties > Properties; clear the Locked check box under Protection. If you need the slicer to remain usable after protecting the sheet again, allow PivotTable report use when you protect it, and test the slicer afterward.
What unlocking a slicer means
A slicer is a visual filter for an Excel Table or PivotTable. It displays buttons for categories such as region, product, or year, so a reader can filter a report without opening a field’s drop-down menu. Unlocking a slicer changes whether that object is protected when its worksheet is protected. It does not remove a password, change the data, or disconnect the slicer from the report it filters.
Excel objects, including slicers, have a Locked property. That property matters when worksheet protection is turned on: a locked object is protected from certain edits, while an unlocked object can remain available for permitted interaction. With the sheet unprotected, the Locked setting does not prevent ordinary use. This is why someone may clear the box and see no immediate change, then notice a difference only after protecting the sheet.
People often mean one of two things by “unlock a slicer”: make its buttons work on a protected worksheet, or make it possible to move, resize, or delete the slicer. Clearing Locked can help with both, but sheet-protection permissions and the object’s specific action matter. If the sheet is protected, you may need to unprotect it before you can change the object’s setting.
Unlock a slicer in Excel for Microsoft 365 on Windows
Use these steps in the desktop version of Excel for Microsoft 365 on Windows. Save the workbook before changing protection settings, especially if you are unsure who owns the password or how the sheet is meant to be used.
- Open the worksheet containing the slicer. If you cannot select or edit it because the sheet is protected, go to Review > Unprotect Sheet. Enter the password if Excel requests one. If you do not know it, ask the workbook owner; do not assume that the object can be unlocked without the required permission.
- Right-click the slicer’s border, rather than one of its filter buttons. Choose Size and Properties. If it is hard to select, use Home > Find & Select > Selection Pane, if available, to locate the slicer in the object list and select it.
- In the Format Slicer pane, open Size & Properties, then Properties. Expand Protection if it is collapsed, and clear Locked. The pane’s labels or layout can vary slightly with Excel updates, but the setting is the object’s Locked property.
- Close the pane and, if required, protect the worksheet again using Review > Protect Sheet. Choose the permissions appropriate for the workbook. If users need to filter a PivotTable with the slicer, allow Use PivotTable reports when that option is offered.
- Test the result while the sheet is protected. Click a slicer button, then use the clear-filter button in the slicer header to restore all items. Also verify that users can still perform only the actions you intend to permit.
When the worksheet is not protected, the slicer can usually be selected and edited regardless of whether Locked is checked. If your goal is to reposition or resize it, unprotecting the sheet and changing Locked is often the straightforward route. Re-protect the sheet only after arranging the slicer and checking the workbook’s behavior.
Using a slicer on a protected worksheet
Worksheet protection and slicer locking are related but separate controls. Clearing Locked does not by itself protect the rest of the sheet, and protecting the sheet does not automatically make every slicer action available. The Protect Sheet dialog controls which actions users may perform. For a PivotTable report, the relevant permission is commonly labeled Use PivotTable reports; enable it if users need to interact with the report and its slicer.
Protection settings should be tested in the same way that workbook users will use the file. After protecting the sheet, try selecting several slicer buttons and clearing the filter. Then test whether users can type in cells or change other objects. If the slicer is still unavailable, turn protection off and check the slicer’s Locked setting, then review the permissions selected when you protected the sheet. Different workbook structures and Excel builds can affect which interactions are available.
For a slicer connected to an Excel Table rather than a PivotTable, do not assume that PivotTable permissions describe every relevant action. Confirm that the filter works under the actual sheet-protection settings in your version of Excel. If the protected-sheet behavior does not meet your needs, consider leaving the report sheet unprotected while protecting sensitive input ranges or distributing a view-only copy.
Locked, hidden, and workbook protection are different
Excel has several protection controls, and confusing them can make a simple slicer problem seem more serious than it is:
- Slicer Locked property: An object-level setting that determines how the slicer is treated when worksheet protection is enabled. It does not set a password.
- Worksheet protection: A sheet-level control that restricts actions such as editing cells or objects. It is managed from the Review tab and can be password-protected.
- Workbook structure protection: A workbook-level control that can restrict actions such as adding, deleting, moving, or renaming sheets. It is not the same as protecting a worksheet.
- Hidden object setting: A separate object property that can affect whether an object is shown or exposed in certain situations. Clearing Locked does not make a hidden slicer visible.
Worksheet protection is intended to prevent accidental changes; it should not be treated as strong security for confidential information. Do not rely on a locked slicer, a protected sheet, or a hidden worksheet to keep sensitive data secret. Use appropriate access controls and avoid distributing data that recipients should not see.
Why a slicer may still seem locked
If you cleared Locked but nothing changed, start by checking whether the worksheet is actually protected. The setting affects behavior under protection, so it may not produce a visible difference on an unprotected sheet. If the slicer still cannot be selected, another object may be covering it, the Selection Pane may help identify the right object, or the workbook may have additional restrictions.
Common causes and checks include:
- The sheet is protected: Use Review > Unprotect Sheet, provided you have permission and the password if requested. Then confirm the slicer’s setting.
- The wrong object is selected: Right-click the slicer frame, not an individual button, or select its name in the Selection Pane.
- The slicer is hidden behind another object: Use the Selection Pane to select it, then adjust its position or arrange the objects while the sheet is unprotected.
- The slicer works but cannot be moved: Filtering and object layout are different actions. Check the Locked property and sheet permissions, and make layout changes with protection turned off.
- The filter buttons are disabled: Recheck protection permissions and confirm the slicer is connected to a valid Table or PivotTable. A disconnected or deleted source can cause problems that unlocking will not fix.
- The workbook is read-only or restricted: Check whether it opened in Protected View, read-only mode, or a shared location with editing restrictions. Resolve the access issue with the workbook owner.
If Excel asks for a password when you choose Review > Unprotect Sheet, the slicer’s Locked box is not a way around that password. Ask the file owner or administrator for authorized access. There is no normal in-Excel setting that grants permission to alter a protected sheet without the required access.
Slicer connections and filters
Unlocking changes object protection, not what the slicer filters. A slicer for a Table filters that Table; a slicer for a PivotTable filters the report fields associated with it. A PivotTable slicer can sometimes control multiple PivotTables, but only when their data sources and report connections support that arrangement. A slicer that changes one report but not another may need its report connections reviewed rather than its Locked property changed.
To inspect a PivotTable slicer’s connections, select it and look for the Report Connections or PivotTable Connections command on the slicer’s contextual ribbon tab. The wording and availability depend on the selected slicer and Excel build. Check the boxes for the reports it should control, then test each report. If a desired report is unavailable, the PivotTables may not share a compatible source or cache; unlocking the slicer does not resolve that structural issue.
Also distinguish clearing a filter from deleting a slicer. The clear-filter icon in the slicer header removes the active selection and restores all items, subject to the report’s data. Deleting the slicer removes the visual control, but does not necessarily delete the underlying Table, PivotTable, or source data. Confirm what you are selecting before using Delete.
Excel for Mac and Excel for the web
The instructions above describe Excel for Microsoft 365 on Windows. In Excel for Mac, the same general distinction applies: the worksheet must be unprotected before you can change protected object settings, and the slicer’s formatting or properties controls may appear in a differently arranged pane. Look for the slicer’s Format or Size & Properties controls and its Protection settings; ribbon labels and available commands can vary by release. Test the slicer after protecting the sheet rather than assuming Windows protection behavior transfers exactly.
Excel for the web can handle some slicer interactions in supported workbooks, but editing options and protection controls may differ from the desktop app. If you cannot find the Locked property or the needed sheet-protection permission in the browser, open the workbook in the Excel desktop app and make the change there. A user’s ability to edit can also depend on file permissions and the workbook’s sharing setup.
Safer ways to share a filtered report
Before distributing a workbook, decide whether recipients need to filter data, edit the report layout, or change the source information. These are different needs. A well-configured report can leave slicer buttons usable while limiting edits to cells or objects that should remain unchanged, but protection can constrain more than expected. Test with a copy of the workbook and, where practical, with an account that has the same access level as the intended reader.
- Keep an unmodified backup before changing protection settings.
- Protect only after the slicer and report layout are finalized.
- Use worksheet permissions to reduce accidental edits, not as a substitute for access control over sensitive data.
- Explain to recipients how to clear filters so they do not mistake a filtered report for missing data.
- If users only need to view results, consider sharing a PDF or another suitable read-only output instead of an editable workbook.
Frequently Asked Questions
How do I unlock a slicer without a password?
If the worksheet is unprotected, you can change the slicer’s Locked property without a sheet password. If Excel requires a password to unprotect the sheet, contact the workbook owner; the Locked setting does not bypass sheet protection.
Does unlocking a slicer let me move or resize it?
It can allow object changes when the worksheet is protected, depending on the sheet’s protection settings. The simplest way to move or resize a slicer is to unprotect the sheet, make the layout change, and then protect it again if needed.
Why can I click the slicer but not change the filter?
Check whether sheet protection permits the required report interaction, and confirm that the slicer is connected to the intended Table or PivotTable. A slicer’s Locked setting alone does not guarantee that filtering is permitted.
Will unlocking a slicer remove its password?
No. The Locked property is not a password and does not remove worksheet or workbook protection. You need authorized access to change protection settings that require a password.
Can one slicer filter several PivotTables?
Sometimes. The PivotTables must support a shared slicer connection, and the reports must be selected in the slicer’s Report Connections or PivotTable Connections options. If a report is missing from that list, check whether its data source is compatible.
Related
- SharePoint Corrupted Excel File? Recovery Steps
- Scenario Manager in Excel: How It Works and When to Use It
- Scenario Manager in Excel: Meaning and How to Use It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Not Responding? Causes, Fixes, and Recovery StepsIf Excel is not responding, wait briefly to see whether it is finishing a calculation or loading a…
- Monthly Calendar in Google Sheets: Create or DownloadTo make a monthly calendar in Google Sheets, enter a date from the month in a cell such…
- Google Sheets 2D Data Validation: How to Set It UpGoogle Sheets does not have a special “2D data validation” rule that reads a grid and automatically chooses…
- Load Excel Data Into a SQL Table: A Practical GuideTo load Excel data into a SQL table, first clean and check the worksheet, then import it with…
- Reset Dropdowns in Google Sheets: Quick FixesTo reset a dropdown in Google Sheets, select the cell and press Delete or Backspace to clear its…
- Excel MIN and MAX Dates: Find the Earliest and LatestWith dates in A2:A100, use =MIN(A2:A100) to return the earliest date and =MAX(A2:A100) to return the latest. If…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.