C3Excel · Pivot Tables · How-to
In Excel, how do you make a pivot table ignore just one specific slicer but obey the rest?
Right-click the slicer you want one pivot to ignore, choose Report Connections, and untick that one pivot table in the list. The slicer stays wired to every other pivot, and that pivot keeps obeying every other slicer. No duplicate data, no second slicer, no macro.
- 1Click the slicer once to select it.
- 2Right-click → Report Connections.
- 3Untick the pivot that should ignore it.
- 4OK. Done.
Live demo
Wire it up yourself
Three slicers, two pivot tables, and the wiring board that decides who listens to whom. Click slicer buttons to filter. Toggle a cell on the board to connect or disconnect a pivot from a slicer, then watch which pivot moves and which one holds still.
Slicers
Report Connections
Lit = the pivot obeys that slicer. Dim = it ignores it. This is the same list Excel shows you inside each slicer's Report Connections dialog.
Pivot tables · Sales by category
All slicers selected, every pivot connected. Nothing is filtered yet.
01The exact steps
The setting that does this is Report Connections (it was called PivotTable Connections in Excel 2010). It lives on the slicer, not on the pivot. Here is the whole thing:
- 1Select the slicer you want one pivot to ignore. A single click on the slicer box is enough.
- 2Right-click it and choose Report Connections. Same command lives on the ribbon: with the slicer selected, open the Slicer tab and click Report Connections in the middle.
- 3The dialog lists every pivot table that shares this slicer's source data. Ticked boxes are the pivots the slicer currently controls.
- 4Untick the one pivot that should ignore this slicer. Leave every other box ticked.
- 5Click OK. That pivot now ignores this slicer and keeps obeying all the rest. Repeat per slicer if you want a pivot to ignore more than one.
Select the PivotTable reports you want to connect to this slicer.
- PivotTable1 Sales!$B$3
- PivotTable2 Sales!$H$3click to untick
- PivotTable3 Sales!$B$22
02Why this works
A slicer is not glued to a pivot table. It holds a list of connections. When you click a slicer button, Excel pushes that filter out to every pivot on the list. Remove a pivot from the list and the slicer simply stops talking to it, while all of its other connections stay exactly as they were.
Crucially, the reverse is also true. Each pivot keeps its own separate connection to every other slicer. Detaching one wire never touches the others, which is why the pivot can obey the rest without a hitch.
Report Connections only lists pivots that share the same source data (the same PivotCache, or the same Data Model). If the pivot you want to free isn't in the list at all, that is good news: it already uses a different source, so the slicer was never controlling it in the first place.
03The variants you'll hit
Timelines (date slicers)
Identical. Right-click the timeline, choose Report Connections, untick the pivot. A timeline is just a slicer for dates.
PivotCharts
A chart follows its underlying pivot. Untick that pivot and the chart stops reacting to the slicer too. There is no separate connection for the chart.
Data Model / Power Pivot
Same dialog, same untick. It works across OLAP pivots built on the Data Model exactly as it does for classic pivots.
Can't find the button?
Select the slicer first, then the Slicer tab appears. In Microsoft 365 the tab is sometimes just labelled Slicer; in 2010 the command reads PivotTable Connections.
04What not to do
- Duplicating the dataset to build a "clean" pivot. Unnecessary, and it doubles your maintenance.
- Adding a second slicer for the same field. Both slicers would still filter the pivot. This is a connection problem, not a slicer-count problem.
- Deleting the slicer. That removes it for every pivot at once, not the single one you meant.
- Hunting for a per-pivot setting. There is no "ignore this slicer" checkbox on the pivot itself. The control lives only in the slicer's Report Connections.
05Quick questions
Does this duplicate my data or slow the workbook down?
No. Report Connections only changes which pivots a slicer talks to. There is no extra copy of the data, no second cache, and no macro. It is a wiring change, not a data change.
Will the slicer still filter my other pivot tables?
Yes. Only the pivot you untick is detached. Every pivot that stays ticked keeps responding to the slicer exactly as before.
The pivot I want isn't listed in Report Connections. Why?
The dialog only shows pivots that share this slicer's source data (the same PivotCache or Data Model). If yours isn't listed, it already uses a different source, so the slicer was never controlling it. It is already independent.
Can one slicer control pivots built on different sources?
Not directly. A slicer can only connect to pivots that share its cache or Data Model. To steer pivots from different sources with one control, put them on the same Data Model, or use a synced pair of slicers.
How do I reconnect the pivot later?
Reopen the same Report Connections dialog for that slicer and tick the box again. The pivot resumes obeying it instantly.
In one line: the power is in Report Connections. Untick one pivot from one slicer and you get surgical control without touching your data.