Excel slicer connections determine which PivotTables respond when you click a slicer. In Excel for Microsoft 365 on Windows, select the slicer, open the Slicer tab, choose Report Connections (sometimes labeled PivotTable Connections), and check the PivotTables you want it to control; those pivots must share a compatible data source or PivotTable cache.
What an Excel slicer connection does
A slicer is a visual filter: its buttons let you choose values such as a region, product, or year without opening a filter menu. A connection tells Excel which PivotTables should respond to that choice. For example, a Region slicer might filter a sales-by-month PivotTable and a sales-by-product PivotTable at the same time.
The connection changes the filtered view of the selected PivotTables. It does not combine their data, change their source ranges, or create a new calculation. Each PivotTable still has its own layout, measures, and displayed results. If a report includes charts based on connected PivotTables, those charts generally update as their underlying PivotTables change.
It helps to distinguish a slicer connection from a relationship in the Data Model. A relationship connects tables of data so a PivotTable can use related fields. A slicer connection links a slicer to one or more PivotTables so they respond to its selections. A report may need both: relationships to build the analysis, and slicer connections to coordinate its controls.
How to connect a slicer to multiple PivotTables
First create the slicer from a PivotTable, then use its connection dialog to add other eligible PivotTables. In Excel for Microsoft 365 on Windows:
- Click inside the PivotTable that should supply the slicer field.
- Choose PivotTable Analyze > Insert Slicer, select one or more fields, and choose OK.
- Click the slicer. Open the Slicer tab on the ribbon and choose Report Connections. In some builds or contexts, the command is called PivotTable Connections.
- In the dialog, check each PivotTable that should respond, then choose OK.
- Click a slicer button and confirm that the intended PivotTables update. Clear the selection with the filter-clear icon in the slicer when you want to restore all items.
The connection dialog only lists PivotTables Excel considers compatible with that slicer. If a PivotTable is missing, checking boxes is not a way to override the underlying source or cache limitation; investigate how the PivotTables were created instead. You can reopen Report Connections at any time to change which listed PivotTables are controlled.
On Excel for Mac, slicers and PivotTables are available, but ribbon placement and wording can vary by release. Select the slicer and look for the Slicer tab and its report or PivotTable connection command. Excel for the web has a more limited feature set than the Windows desktop app, so use the desktop application if the connection command or a needed editing option is unavailable.
Why some PivotTables are unavailable
The most common reason is that the PivotTables do not share a PivotTable cache or compatible source. A cache is Excel’s stored representation of the source data used by a PivotTable. Two PivotTables can be based on ranges that look identical yet have separate caches, especially if each was created independently. In that case, a slicer created for one may not offer the other in its connection list.
Data source differences can also prevent a shared connection. For example, one PivotTable may use an Excel table while another uses a manually selected range, or the pivots may use different source tables, connections, or models. A field with the same visible label does not, by itself, make two PivotTables compatible. What matters is their underlying source and how Excel built the pivots.
For PivotTables built from the Data Model, check that they use the same workbook Data Model and that the slicer field is available to the pivots. A workbook can contain multiple external connections or distinct models, and a slicer cannot coordinate unrelated pivot sources simply because their captions match. Also verify that the field is suitable for use in the relevant PivotTables.
Ways to make PivotTables share a slicer
If a target PivotTable is absent from Report Connections, the cleanest fix is often to build the PivotTables from a common source in a consistent way. For ordinary range or table data, create the first PivotTable, then create additional PivotTables by copying it and changing the field layout. This commonly allows the pivots to share a cache, though confirm the result in the connection dialog rather than assuming.
For larger or related datasets, the Data Model may be a better foundation. Add the tables to the model, establish the required relationships, and create the report PivotTables from that model. Pivots that use the same model can often share slicers when the relevant fields are compatible. This approach is useful for a report that combines, for example, a Sales table with Product and Calendar tables, but it requires a correctly designed model.
Before rebuilding a workbook, make a copy and inspect the source details of each PivotTable. Recreating pivots can affect formatting, calculated fields, chart links, and report layout. If the report is already complex, test the approach in a duplicate workbook first. There is no general checkbox that merges separate caches after the fact; recreating the pivots consistently is usually more reliable than trying to force a connection.
Connecting slicers to Excel tables
Excel also allows slicers for ordinary formatted tables. Click in the table and choose Table Design > Insert Slicer, then select a column. This is distinct from inserting a slicer from a PivotTable: a table slicer filters rows in its own table, while a PivotTable slicer filters PivotTables that can share its pivot source.
A slicer for a regular Excel table cannot be connected through Report Connections to a PivotTable, and table slicers do not provide a general way to control multiple separate tables. If a report needs one selection to coordinate several PivotTables, create the slicer from a PivotTable and connect eligible pivots. If the report is based on a normal table, one option is to make PivotTables from that table and use a PivotTable slicer instead.
This distinction explains a common surprise: two slicers may look identical and filter a column with the same name, but they are not interchangeable. Their connection options depend on whether they belong to an Excel table or a PivotTable, and on the underlying source structure.
Using several slicers and reading the results
A report can use multiple slicers, such as Region, Product, and Year. Each slicer can have its own list of connected PivotTables. To see or change those links, select each slicer separately and open its Report Connections dialog. Do not assume that connecting one slicer automatically connects every other slicer on the sheet.
Selections across slicers combine as filters. If Region is set to West and Year to 2025, a connected PivotTable shows records meeting both conditions, subject to the available data and fields. When a selection leaves no matching records, a PivotTable can appear blank or show no values; that does not necessarily mean its connection is broken. Clear one or more slicers to test whether the data reappears.
Users can select multiple slicer items when the slicer allows it, using its multi-select control or the relevant selection behavior in the Excel version. Items that are unavailable under another active filter may appear faded or otherwise indicate that they have no matching data. That is a filtering effect, not proof that the slicer is disconnected.
Common connection problems and checks
- The PivotTable is missing from the dialog: check whether it uses the same source, PivotTable cache, or Data Model as the slicer’s PivotTable. Similar labels or identical-looking source data are not sufficient.
- The slicer changes one pivot but not another: reopen Report Connections and make sure the second pivot is checked. Confirm that you selected the intended slicer, especially if the sheet contains several.
- A slicer choice produces an empty pivot: clear other active slicers and check whether the selected value exists in the pivot’s source data. Multiple filters can leave no matching rows.
- New source values do not appear: refresh the PivotTable or use Data > Refresh All, then check the source range or table. A connection does not automatically expand an incorrectly defined source range.
- One pivot behaves differently after refresh: compare its source and model with the others, and review the selected connections again. Refreshing updates data; it does not necessarily make separately built caches compatible.
When troubleshooting, change one thing at a time: clear slicer filters, refresh the data, inspect the connection list, and test a known value. This makes it easier to tell the difference between a missing connection, a source-data issue, and a selection that simply has no matching records.
Slicers compared with filters and timelines
Traditional PivotTable report filters can also filter a PivotTable, but they usually appear as dropdown controls rather than a panel of buttons. Slicers make the current selection more visible and are convenient for dashboards. A report filter is still useful when sheet space is limited or when a compact control is preferred.
A Timeline is a specialized visual filter for date fields in PivotTables. It can let a reader choose a period such as a month, quarter, or year, depending on the available dates. Like a slicer, a Timeline can connect to compatible PivotTables, but it is designed for dates rather than general categories. It does not remove the need for compatible sources.
Frequently Asked Questions
Can one slicer control multiple PivotTables?
Yes, if the PivotTables are compatible with the slicer, commonly because they share a PivotTable cache or use the same Data Model. Select the slicer, open Report Connections, and check the pivots to control.
Why can’t I see a PivotTable in Slicer Connections?
It likely uses a different cache, source, or model, or is otherwise incompatible. Pivots based on the same-looking data can still have separate caches. Rebuild them from a common source and verify the connection dialog.
Can a slicer for an Excel table control a PivotTable?
No. A table slicer filters its table; a PivotTable slicer connects to compatible PivotTables. To coordinate PivotTables, create the slicer from a PivotTable.
Do slicer connections update automatically when data changes?
The connection determines which pivots respond to selections; it does not replace refreshing the PivotTable data or fixing its source range. Refresh the relevant data when new or changed records need to appear.
Can I connect one slicer to PivotTables with different layouts?
Yes. Connected PivotTables can summarize the same compatible source in different ways, such as by month and by product. Their layouts remain independent even though the slicer filters both.
Related
- Excel Protect Sheet: How to Select Unlocked Cells Only
- Excel Protect Sheet Greyed Out? Causes and Fixes
- Excel Protected Sheet: Can a Table Still Grow?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Rank in Excel with RANK.EQTo rank numbers in Excel, enter =RANK.EQ(B2,$B$2:$B$6,0) in a cell beside the first number, then fill the formula…
- How to Change Your Name on Track Changes in Microsoft WordTo change the name Word attaches to new tracked edits, update the Office user name: in Word for…
- Excel Group and Ungroup Shortcuts for Rows and ColumnsTo group rows or columns in Excel for Microsoft 365 on Windows, select the rows or columns and…
- Conditional Formatting for Absolute Values in ExcelTo conditionally format values by their absolute size in Excel for Microsoft 365 on Windows, create a formula…
- Box Plot in Excel: Create and Read One Step by StepTo create a box plot in Excel for Microsoft 365 on Windows, place each group of raw numeric…
- Excel Table Absolute References: How They WorkExcel tables do not use dollar signs to make structured references absolute: a reference such as Orders[Amount] continues…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.