Pivot Table Issues

Use Excel Slicers with a Table and Multiple PivotTables

John WilsonJohn Wilson Nov 18, 2026 871 views

Question details

The user wants one or more slicers to filter both an Excel table and a PivotTable.

Use Excel Slicers with a Table and Multiple PivotTables
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user is analyzing the same data in a regular Excel table and a PivotTable and wants to control both with slicers.
Observed behavior
A slicer created for the regular table cannot be connected directly to a separate PivotTable.
Before you start

Check whether the objects are a regular Excel table or PivotTables. If you want a slicer to control multiple PivotTables, they must share a compatible PivotTable cache or Data Model.

Solution 1Recommended

Connect one slicer to compatible PivotTables

Use this approach when you can replace the table view with another PivotTable and want a shared slicer to control both analyses.

A slicer attached to a regular Excel table cannot directly filter a separate PivotTable. PivotTables built separately from the same source do not necessarily share a compatible cache; copying an existing PivotTable is one way to preserve a shared cache.

1
Create the first PivotTable

Click a cell in the source table, select Insert > PivotTable, and choose where to place it.

2
Create a compatible second PivotTable

Copy the first PivotTable and paste it into another location. Change its fields or layout to create the second view of the data.

3
Insert a slicer

Click either PivotTable, select PivotTable Analyze > Insert Slicer, choose a field, and click OK.

4
Connect the PivotTables

Select the slicer, open the Slicer tab, and choose Report Connections or PivotTable Connections. Check both PivotTables and click OK.

5
Test the filter

Click an item in the slicer and confirm that both PivotTables update.

Connect one slicer to compatible PivotTables
Regular tables remain separate: The shared slicer controls the connected PivotTables, not the original Excel table. A PivotTable view summarizes data and may not display duplicate source rows individually.
Free Microsoft Office alternative

Explore spreadsheet analysis with WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel formats, making it easy to bring existing workbooks into your workflow. It does not fix Excel slicer connections, and existing workbook features should be checked after opening.

Analyze spreadsheet data in a familiar interfaceOpen and work with Microsoft Excel XLSX and XLS filesUse a free, lightweight office suite for everyday work
microsoft office alternative - wps office

Frequently Asked Questions

Can an Excel table slicer also control a PivotTable?

No. A slicer created for a regular Excel table cannot directly control a separate PivotTable. Use a PivotTable slicer connected to compatible PivotTables instead.

Why is my second PivotTable missing from Report Connections?

The PivotTables may not share a compatible cache or Data Model. Try copying the first PivotTable to create the second, then select the slicer and open Report Connections again.

Can one slicer control several PivotTables?

Yes. Select a PivotTable slicer, open Slicer > Report Connections or PivotTable Connections, and check the compatible PivotTables you want to filter.

Will a shared PivotTable slicer filter the original source table?

No. It filters the connected PivotTables, while the original Excel table remains separate. Use the table's own filters if you need to filter its rows.