Can One Excel Slicer Filter Multiple Regular Tables?
Question details
Find out whether one Excel slicer can filter multiple regular tables and what alternatives are available.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to filter several independent Excel tables using a single slicer.
- Observed behavior
- A regular table slicer filters only its associated table. Multiple PivotTables can share a slicer when they use the same pivot cache.
Check whether your data is in regular Excel tables or PivotTables. If you plan to combine tables, compare their column names and data types first.
Combine the data into one Excel table
Use one regular table and its slicer when the datasets have compatible columns and can be analyzed together.
Copy the rows from each source table into one continuous range, aligning matching columns under a single header row.
Select the combined range, choose Insert > Table, confirm that the table has headers, and select OK.
Click inside the new table, choose Insert > Slicer, select the column you want to filter, and click OK.
Click a value in the slicer to filter the rows in the combined table.

Connect one slicer to PivotTables with a shared cache
Use this approach when you need separate PivotTable reports controlled by one slicer.
Work with spreadsheet tables in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and work with table data as you transition between Office applications; it does not remove Excel's slicer limitation.

Frequently Asked Questions
Why can't I connect a table slicer to another regular table?
A slicer created for a regular Excel table is associated with that table. Unlike compatible PivotTables, independent regular tables do not share a pivot cache for slicer connections.
How can I filter two regular tables without combining them?
Add a separate slicer to each table using Insert > Slicer, or use the filter arrows in each table's headers. Each table must be filtered independently.
Why doesn't my PivotTable appear in Report Connections?
Select the slicer and open Report Connections to check the available reports. A PivotTable that does not share the slicer's pivot cache may not appear; copying an existing PivotTable is one way to create another report that shares its cache.
Will filtering a combined table also filter my original tables?
No. A slicer on the combined table filters that table only. The original tables remain separate unless you change their own filters.




