Pivot Table Issues

Can One Excel Slicer Filter Multiple Regular Tables?

Aamir Naveed AkramAamir Naveed Akram Nov 18, 2026 869 views

Question details

Find out whether one Excel slicer can filter multiple regular tables and what alternatives are available.

Can One Excel Slicer Filter Multiple Regular Tables?
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.
Before you start

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.

Solution 1Recommended

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.

1
Consolidate the rows

Copy the rows from each source table into one continuous range, aligning matching columns under a single header row.

2
Create a table

Select the combined range, choose Insert > Table, confirm that the table has headers, and select OK.

3
Add a slicer

Click inside the new table, choose Insert > Slicer, select the column you want to filter, and click OK.

4
Filter the combined data

Click a value in the slicer to filter the rows in the combined table.

Combine the data into one Excel table
One table, not multiple connections: The slicer filters the combined table; it does not filter the original independent tables.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLS and XLSX filesOrganize and filter spreadsheet data in WPS SpreadsheetUse a familiar interface for a smoother move from Microsoft OfficeAccess a lightweight office suite with a free option
microsoft office alternative - wps office

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.