Your Excel slicer appears but clicking it does not filter your PivotTable or PivotChart. This problem occurs when the slicer loses its connection to the underlying data source. The slicer becomes a visual object with no functional link to your report. This article explains how to re-establish that connection and get your slicer working again.
Key Takeaways: Fixing a Disconnected Slicer
- Slicer Settings > Report Connections: Re-links a slicer to one or more PivotTables in the current workbook.
- PivotTable Analyze > Insert Slicer: Creates a new, properly connected slicer from the active PivotTable.
- Data > Refresh All: Updates the PivotTable cache, which can restore slicer functionality after data source changes.
Why Slicers Lose Their Connection to Data
A slicer is a visual filter controller tied to a specific PivotTable cache. Every PivotTable created from the same data range shares a cache. The slicer connects to this cache, not directly to the raw data. The connection breaks if the original PivotTable is deleted, if the workbook structure changes significantly, or if you copy a slicer from another workbook without its associated PivotTable. A slicer can also stop working if its source PivotTable is converted to static values or if the data model relationships are altered. The slicer remains on the sheet, but its filter commands go nowhere.
The Role of the PivotTable Cache
The PivotTable cache is a snapshot of your data stored in Excel’s memory. Slicers and timelines interact with this cache. If you have two PivotTables from the same source, they likely share one cache. A slicer connected to that cache can filter both tables. Problems start when that cache is cleared, modified, or when a PivotTable uses a different, isolated cache. Without a shared cache, the slicer cannot communicate with the PivotTable.
Steps to Reconnect a Slicer to Your PivotTable
Follow these steps to restore the filtering function of your slicer. Start with the first method, which directly repairs the existing link.
- Select the non-working slicer
Click once on the slicer object on your worksheet. You will see the Slicer contextual tab appear on the ribbon. - Open the Report Connections dialog
Go to the Slicer tab on the ribbon. Click the Report Connections button. This dialog lists all PivotTables in the workbook that share a compatible data source. - Re-establish the connection
In the Report Connections dialog, check the box next to the PivotTable you want the slicer to filter. If multiple PivotTables are listed, you can select several. Click OK to confirm. - Test the slicer
Click on an item within the slicer. Your connected PivotTable should now filter and update immediately to reflect the selection.
Creating a New Slicer from Scratch
If the Report Connections dialog is empty or the fix does not work, create a new slicer. This method guarantees a fresh connection.
- Click inside your target PivotTable
Select any cell within the PivotTable you need to filter. - Insert a new slicer
Go to the PivotTable Analyze tab on the ribbon. Click the Insert Slicer button. - Choose the slicer field
In the Insert Slicers dialog, check the box for the field you want to use for filtering. This is typically a column like Region, Product, or Date. Click OK. - Position and use the new slicer
Excel places the new slicer on your sheet. You can move and resize it. Clicking any item will now filter the original PivotTable. You can delete the old, non-working slicer.
If Your Slicer Still Does Not Filter Data
Slicer is Grayed Out or Inactive
A grayed-out slicer usually means the PivotTable has no data. Refresh the PivotTable by clicking inside it and going to PivotTable Analyze > Refresh. If the data source range has changed, update it via PivotTable Analyze > Change Data Source. Ensure the new range includes all your data.
Slicer Filters Only One of Multiple PivotTables
This happens when PivotTables are built from separate data caches. To fix it, ensure all PivotTables use the same source. Create the second PivotTable by copying the first one and changing its layout, not by creating a brand new one from the data range. Then, use the Report Connections dialog to link the slicer to both tables.
Slicer Created for a Table Does Not Work
Slicers for standard Excel tables work differently than PivotTable slicers. If a table slicer fails, check that the table range is correct. Click inside the table, go to the Table Design tab, and verify the range in Properties > Resize Table. Also, ensure no filters are applied manually to the table columns that conflict with the slicer.
Methods to Fix a Disconnected Slicer: Comparison
| Item | Using Report Connections | Creating a New Slicer |
|---|---|---|
| Best For | An existing slicer that just lost its link | A completely broken slicer or a new filtering need |
| Speed | Fast, repairs the current object | Takes longer, adds a new object to the sheet |
| Complexity | Simple two-step dialog | Requires inserting and formatting a new slicer |
| Outcome | Restores function to the original slicer | Guarantees a fresh, working connection |
You can now fix a slicer that is not filtering your Excel reports. Use the Report Connections dialog for a quick repair or insert a new slicer for a guaranteed fix. For advanced control, use the Data Model and create relationships between tables to build more powerful, cross-filtering dashboards. Remember to refresh your PivotTables with Alt+F5 after changing the source data to keep slicers responsive.