Yes—one slicer can control multiple PivotTables when they share the same PivotTable cache or use the same Excel Data Model. If you mean ordinary Excel Tables (the formatted ranges with filter buttons), a table slicer cannot directly control several separate tables; use PivotTables or a model-based report instead.
What “multiple tables” can mean in Excel
People use “table” to describe two different things in Excel. An Excel Table is a structured range created with Insert > Table; it has column headers, filter buttons, and a name such as Sales. A PivotTable is a summary report built from data. The way a slicer connects depends on which one you mean.
A slicer added to an Excel Table filters that one table. It does not have the PivotTable Report Connections feature that lets a slicer control several compatible PivotTables. By contrast, a slicer attached to a PivotTable can often filter several PivotTables at once, provided Excel recognizes them as sharing a data source. That distinction explains why selecting a slicer and looking for a connection checkbox may work for a PivotTable report but not for a slicer attached directly to a regular table.
For example, if a workbook has separate Sales and Returns tables and you want one Region slicer to affect summaries of both, the reliable design is to create compatible PivotTables from a shared source or build both into the Data Model. Simply inserting a slicer on Sales will not make it control Returns.
How slicer connections work
A slicer is a visual filter. Its buttons represent values in a field, such as Region, Product, or Month. When you click a value, Excel applies that selection to the PivotTable or table linked to the slicer. A PivotTable slicer can also pass the selection to other PivotTables, but only when those reports are eligible to share it.
For conventional PivotTables, eligibility usually means the reports use the same PivotTable cache. The cache stores the source data and supports the report. Two reports can show the same source range yet still have separate caches if they were created independently, so matching field names alone do not guarantee that they can share a slicer.
PivotTables built on the Excel Data Model can share slicers when they use that same model. The model can contain related tables, so one slicer from a shared dimension—such as a Regions table—can filter reports built from different fact tables. Relationships and compatible fields matter: a slicer cannot filter data that has no usable relationship to the tables in a report.
Connect one slicer to several PivotTables
In Excel for Microsoft 365 on Windows, first make sure the PivotTables are compatible. If you are creating them from the same source, a practical way to preserve a shared cache is to copy an existing PivotTable and then change the copied report’s layout. Separately created PivotTables may or may not share a cache, even if they use the same-looking data range.
- Click inside the first PivotTable and choose PivotTable Analyze > Insert Slicer.
- Select the field you want to filter by, such as Region, then select OK.
- Click the slicer. On the contextual Slicer tab, choose Report Connections. In some Excel releases or layouts, the command may be labeled PivotTable Connections.
- In the dialog, select the eligible PivotTables that the slicer should control, then select OK.
- Click a slicer button and check each report. Clear the filter with the slicer’s Clear Filter button when you want to show all values again.
The connection list is the definitive check: a PivotTable that is not listed cannot be connected through that slicer. If a report is missing, check its source and cache rather than assuming the slicer is malfunctioning. PivotCharts associated with connected PivotTables can reflect the same filtering, but a chart does not make an otherwise incompatible PivotTable eligible.
Use the Data Model for genuinely separate source tables
If your data is stored in several related Excel Tables, adding those tables to the Data Model is often the best design. For instance, a workbook might have a Sales table containing OrderDate, ProductID, and Amount, a Returns table containing ProductID and ReturnDate, and a Products table containing ProductID and Category. A single Products table can provide product and category information to both report types when the relationships are set up appropriately.
To start, make each source range an Excel Table and give it a clear name. When creating a PivotTable, use Insert > PivotTable and select the option to add the data to the Data Model where available. Add the other tables to the model as well, then create relationships using Data > Relationships. The key on the “one” side of a relationship must identify unique rows; a repeated key on both sides generally cannot serve as a simple one-to-many relationship.
Create the PivotTables from the Data Model, insert a slicer using a field that can filter the related data, and use Slicer > Report Connections to select the model-based PivotTables. A shared lookup or dimension table is usually a better slicer source than a field copied independently into several fact tables. It gives the reports one consistent set of values and avoids mismatches such as a trailing space in one table’s region name.
Relationships do not automatically fix every reporting issue. If two tables are unrelated, or their relationship keys do not match, filtering one table may not affect a report based on the other. Decide what each report is meant to count, and verify totals before relying on a combined dashboard.
Can a slicer control several ordinary Excel Tables?
Not directly. A slicer created from an ordinary Excel Table is a convenient visual filter for that table, but it cannot be assigned to several independent tables with Report Connections. If the goal is to filter several raw data lists simultaneously on a worksheet, Excel’s built-in table slicer does not provide a universal, workbook-wide filter.
There are several sensible alternatives. You can build PivotTables from a shared source or the Data Model and use a connected slicer on the report sheet. If the lists are really parts of one dataset, use Power Query to combine or transform them into a single table before reporting. If the lists need to remain separate, put separate slicers on them and accept that each filters its own table; their selections are not automatically synchronized.
A slicer may look like a dashboard control, but it is not a general-purpose control for arbitrary ranges. Worksheet formulas, filters, and independent tables do not become connected just because they contain a column with the same heading. The data structure and the PivotTable cache or model determine what Excel can filter together.
Choose the right setup
The best route depends on what the source data represents and what readers need to see:
- One source, several summaries: Use PivotTables that share a cache, then connect the slicer through Report Connections.
- Several related source tables: Use the Data Model, create relationships, and build the reports from that model.
- Several unrelated raw lists: Use separate table slicers, or redesign the data if the lists should be compared or filtered together.
- A single filtered list: Add a slicer directly to the Excel Table; a PivotTable is not necessary just to filter that one list.
For a small report, copying a PivotTable to create another view is often simpler than designing a model. For ongoing analysis with multiple related tables, the Data Model is more scalable and makes the intended relationships explicit. Do not add complexity just to make a slicer look connected; choose the structure that represents the data accurately.
Common connection problems and fixes
- A PivotTable is missing from Report Connections: It may use a different cache or a different data source. Rebuild it from the same source, or copy a compatible PivotTable and adjust its fields. For multiple related tables, use a shared Data Model.
- The slicer changes one report but not another: Reopen Report Connections and confirm the other report is checked. Then test a value that actually exists in both reports; a selection can produce no visible change if it does not narrow that report’s data.
- Some expected values are absent: Check for inconsistent spelling, spaces, blanks, or different data types in the source fields. Refresh the PivotTables after correcting source data.
- Refresh causes confusing results: Refresh the PivotTables and confirm that their source ranges include newly added rows. Excel Tables expand as rows are added, but a PivotTable may still need a refresh to display the new data.
- Report Connections is unavailable: Confirm that the selected slicer belongs to a PivotTable, not directly to an ordinary Excel Table. Also select the slicer itself so its contextual ribbon tab appears.
When troubleshooting, change one thing at a time and verify the reports’ totals. A slicer can filter correctly while a source-range or relationship problem still makes the overall result incomplete.
Excel for Mac and Excel for the web
The instructions above use Microsoft 365 for Windows. Excel for Mac also supports PivotTables and slicers, but ribbon organization and available commands can vary by release. Select the slicer and look for its contextual Slicer tab and connection command; if the connection options you need are not available, use the Windows desktop version to configure the workbook and check the result there.
Excel for the web may not expose the same PivotTable and model-management controls as the Windows desktop app. A workbook can still be useful online, but for building relationships, resolving cache differences, or setting up connections, use the desktop app when the needed command is absent. Menu labels and feature availability can change with Excel updates, so the selected object and the contextual ribbon are useful clues.
Frequently Asked Questions
Can one slicer control two PivotTables?
Yes, if both PivotTables are eligible to share the slicer—typically because they use the same PivotTable cache or the same Data Model. Select the slicer and use Slicer > Report Connections to choose both reports.
Can one slicer filter two Excel Tables?
No. A slicer attached directly to an ordinary Excel Table filters that table, not multiple independent tables. Use compatible PivotTables or a Data Model for a shared report filter.
Why is my second PivotTable not listed in Report Connections?
It likely uses a different cache or source. Create the second report by copying a compatible PivotTable, or build both reports from the same Data Model if the sources are related.
Do the tables need identical column names?
Identical names alone do not make tables or PivotTables share a slicer. The reports must share an eligible cache or model. In a model, relationships between tables and the field used by the slicer determine whether filtering flows correctly.
Can I connect a slicer to a PivotChart as well?
A slicer can filter a PivotChart through its associated PivotTable. To control several PivotCharts, connect the slicer to the eligible PivotTables behind them using Report Connections.
Related
- Excel Scatter Plot: How to Create, Format, and Read It
- Excel: How to Split Text Into Two Columns Without Errors
- Excel: How to Center a Print Area on a Printed Page
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Consolidate in Excel: Example, Steps, and Common IssuesTo consolidate data in Excel, place each source range on a separate worksheet, then choose Data > Consolidate,…
- How to Create a Distribution List in OutlookTo create a personal distribution list in Outlook, open People, choose New Contact Group in classic Outlook or…
- Excel File Format or File Extension Corrupted? What to DoIf Excel reports that a file format or file extension is not valid, the extension may not match…
- Excel Named Range Greyed Out? Causes and Fixes to TryIf Excel’s Name Manager or Define Name command is greyed out, first press Enter or Esc to leave…
- Copy Excel Sheet to Word: Methods and FormattingTo copy Excel data into Word, select the cells in Excel, press Ctrl+C, click where the content should…
- Consolidate Data in Excel: Methods and StepsTo consolidate data in Excel for Microsoft 365 on Windows, choose Data > Consolidate, select a summary function…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.