If Excel says “No connections found” when you open a slicer’s Report Connections, it usually means there are no other compatible PivotTables for that slicer to control. The slicer can connect only to PivotTables that share its PivotTable cache or, in some cases, the same Data Model; a slicer made for an Excel table is a different kind and does not offer those PivotTable connections.
What the message means
A slicer is a clickable filter. It is attached to a particular Excel table or PivotTable, and its available connections depend on how that source was created. The Report Connections dialog does not let you connect a slicer to any object in the workbook. It lists eligible PivotTables that can respond to that slicer.
Consequently, an empty list usually describes the workbook’s data structure rather than a fault with the slicer. You may have created the slicer correctly, but Excel cannot find another PivotTable that uses the same underlying cache or compatible model. If the dialog lists only the PivotTable that owns the slicer, there is no second report to select.
The wording and ribbon tab can vary slightly by Excel build. In Microsoft 365 for Windows, select the slicer and look on the Slicer tab for Report Connections. Some releases or contexts label the command PivotTable Connections. The dialog may also display the slicer’s own PivotTable, depending on the workbook and version.
How slicer connections work
When Excel creates a PivotTable, it uses a source and stores or refers to the data through a PivotTable cache, or uses the workbook Data Model. A slicer sends filter selections to compatible PivotTables using that same underlying structure. Two PivotTables can show similar fields and still be incompatible if they were built from separate caches.
This is why matching column names, identical-looking source data, or using the same worksheet range does not always guarantee that two PivotTables can share a slicer. Excel is checking the underlying connection, not merely whether the reports appear to describe the same information.
- PivotTable slicer: Can control its own PivotTable and other eligible PivotTables that share the relevant cache or model.
- Table slicer: Filters the Excel table it was created for. It does not use the PivotTable Report Connections dialog to link unrelated tables or PivotTables.
- Data Model slicer: Can work across PivotTables built from the same workbook Data Model, subject to compatible fields and report setup.
A PivotChart follows the PivotTable it is based on. Connecting a slicer to a PivotTable can therefore affect its associated PivotChart as well; the chart itself is not usually the object you choose in Report Connections.
Check whether the slicer belongs to a table or PivotTable
First determine what object the slicer filters. Click the slicer and inspect the contextual ribbon. If the surrounding controls identify a table slicer, it belongs to an Excel table. Its normal job is to filter rows in that table, not to control a collection of PivotTables. A table slicer showing no PivotTable connections is expected, not evidence that Excel has lost a link.
If you need to filter several PivotTables, create a slicer from one of those PivotTables instead. Select a cell in the PivotTable, then choose PivotTable Analyze > Insert Slicer and select a field. After insertion, select the slicer and choose Slicer > Report Connections. The command is available only when a slicer is selected, and the exact tab wording can vary by release.
Table slicers can still be useful for filtering a structured source table, and Excel tables can feed PivotTables. That does not automatically make the table slicer a shared PivotTable control. If the goal is a dashboard with several PivotTables responding to one click, plan the reports around a common PivotTable cache or Data Model.
Fix: make the PivotTables share a cache
For ordinary PivotTables based on the same source, a practical way to preserve a shared cache is to copy an existing PivotTable and paste it to create another report. Then rearrange its fields to show a different view. Because it is derived from the original PivotTable, the copy is more likely to retain the same cache than a PivotTable created independently from a worksheet range. Check Report Connections afterward rather than assuming the link was retained.
If the reports already exist, compare their sources. Click a PivotTable and look for PivotTable Analyze > Change Data Source. Confirm that the ranges or table sources are truly the same, including the same worksheet, table, and relevant range boundaries. If one report points to a different-sized range or a separate table, that may explain why it is absent from the slicer’s connection list.
Changing the source of a PivotTable is not a universal way to merge separate caches. Excel may continue to treat independently created PivotTables as separate, even when you point them at equivalent data. If connecting them is essential, rebuilding one report by copying a compatible PivotTable can be simpler than trying to repair separate structures. Save a backup before making substantial changes to a workbook.
Fix: use the Data Model for related sources
If reports draw on different tables, the Data Model is often a better design than trying to force separate PivotTable caches together. Add the relevant tables to the workbook Data Model, create relationships using matching key columns, and build the PivotTables from that model. A slicer can then filter compatible reports that use the same model, although the field chosen for the slicer must be available in that model.
For example, a workbook might contain a Sales table and a Products table. If both are in the Data Model and related through a product ID, a PivotTable can use sales amounts and product categories without first combining every column into one worksheet table. Reports based on that same model can then be candidates for a shared slicer.
Adding tables to the model and creating relationships takes more setup than making a simple PivotTable. Relationships also depend on appropriate keys: the column on the one side must identify unique records, and the related columns must have compatible data. If you only have one small flat dataset, a common source table and shared cache are usually more straightforward.
Common causes and what to do
- The slicer was inserted from an Excel table. Its filter applies to that table. Create a PivotTable slicer if the intended targets are PivotTables.
- Each PivotTable was created separately. They may have different caches even if they use similar data. Rebuild a report from a compatible PivotTable, or use a shared Data Model where appropriate.
- The source ranges differ. Check Change Data Source for each report. Standardize the source, then verify whether the reports can share a slicer.
- The reports use different data models or connections. Reports based on separate models or external connections are not automatically made compatible by having similarly named fields. Build them from a common model or use separate slicers.
- The field is not available in the other report. A shared underlying source is important, but the slicer’s field must also make sense in the target report. A missing field can make a connection unusable or unavailable.
- You are selecting the wrong object. Select the slicer itself before opening its connection command. Selecting a worksheet cell or chart shows different ribbon commands.
Refreshing a PivotTable can update its data, but refresh alone does not combine separate caches. Likewise, clearing a filter or deleting and reinserting the slicer does not convert a table slicer into a shared PivotTable slicer. Fix the source relationship or report design first.
Verify the result and keep the dashboard usable
Once the reports share a compatible cache or model, select the slicer and open Report Connections. Tick the PivotTables that should respond, then confirm the selection. Test more than one slicer button and check each report, including any associated PivotCharts. If one report does not change, revisit its source and whether the selected field is present in that report.
Use descriptive names for PivotTables and slicers when a dashboard contains many objects. In Report Connections, meaningful names make it easier to distinguish reports than a list of generic names. You can rename a PivotTable from PivotTable Analyze options, and you can change the slicer caption from its slicer settings. Keep a note of which reports are intended to respond to each slicer so future edits do not create confusing dashboard behavior.
For a clean user experience, avoid connecting a slicer to reports that should not share its filter. A date slicer, for instance, may be appropriate for several sales summaries but not for a separate inventory report whose dates mean something different. A deliberate set of connections is more useful than connecting every eligible PivotTable.
Excel for Mac and Excel for the web
The explanation applies to Microsoft 365 Excel for Windows. Excel for Mac also supports PivotTables and slicers, but ribbon labels and available controls can differ by version. Select the slicer and look for its contextual Slicer tab and connection command. If a command shown in Windows instructions is missing, check that Excel for Mac is updated and that the selected object is a PivotTable slicer rather than a table slicer.
Excel for the web can display and interact with some workbook slicers, but available creation and management features may differ from the desktop app. For diagnosing cache compatibility or restructuring a Data Model, open the workbook in desktop Excel. Do not infer that a slicer has no compatible reports solely because a web version does not expose the same management dialog.
Frequently Asked Questions
Why does Excel say no connections found for my slicer?
There are no eligible PivotTables for the slicer to control. Common reasons are that it belongs to an Excel table, or that the other PivotTables use different caches or Data Models.
Can one slicer control multiple PivotTables?
Yes, when the PivotTables share a compatible PivotTable cache or use the same Data Model. Select the slicer, open Report Connections, and select the reports you want it to filter.
Can I connect a slicer to two Excel tables?
A table slicer filters the table it belongs to; it does not use PivotTable Report Connections to control other tables. To build a multi-report dashboard, consider PivotTables that share a cache or a common Data Model.
Will refreshing the PivotTables make the connection appear?
Not by itself. Refresh updates PivotTable data, but it does not generally combine separate caches. Check how the reports were created and whether they use a common source structure.
Why are PivotTables using the same data not listed?
They may have been created as separate PivotTables with separate caches, or they may use different source ranges or models. Similar data is not enough; the reports need compatible underlying connections.
Does a slicer filter a PivotChart directly?
A PivotChart responds through its associated PivotTable. Connect the slicer to that PivotTable, and check the chart after changing the slicer selection.
Related
- Excel Power Query Value Transformation: Types and Steps
- Excel Power Query Training: Skills, Courses, and Practice
- Excel Power Query Value Replacement: 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
- How to Split Cells in Excel Vertically: Text and LayoutTo split text in an Excel cell into side-by-side columns, select the cells, then choose Data > Text…
- Excel: How to Count Text vs. Numbers in a Range CorrectlyWith values in A2:A20, count numeric cells with =COUNT(A2:A20) and count cells whose values are text with =SUMPRODUCT(--ISTEXT(A2:A20)).…
- Excel Data Validation for Numbers: Rules and ExamplesYes. In Excel for Microsoft 365 on Windows, select the cells, go to Data > Data Validation, and…
- Excel Scatter Plot: How Blank Cells Are HandledYes. In Excel for Microsoft 365 on Windows, an XY scatter plot normally treats truly empty cells as…
- Conditional Formatting Alternate Row Color in ExcelTo alternate row colors in Excel, select the cells to format, choose Home > Conditional Formatting > New…
- Notepad++ Text to Columns: Split, Align, and Edit DataNotepad++ does not have a one-click, Excel-style Text to Columns command. For simple delimited text, you can replace…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.