How to Connect Slicers for Multiple Pivot Tables

Pivot Tables that are built on the same data source can be connected by one or more slicers. Please see here to learn how to insert a filter.

For example, we have a Pivot Table "Average of Salary" by region and we have a "Region" slicer. We add another Pivot Table "Count of ID". The two Pivot Tables are built on the same data source, and we want the slicer to connect the two Pivot Tables.

Step 1: Click anywhere in the second Pivot Table;

Step 2: Click "PivotTable Analyze" Tab in the Ribbon when working with Excel 365;

  • The "Analyze" Tab if Excel 2019 or the "Options" Tab if Excel 2010.
This image has an empty alt attribute; its file name is excelpivrefreshtable02.jpg

Step 3: Click "Filter Connections" in the "Filter" section;

  • If Excel 2010, please click the small triangle under "Insert Slicer", then select "Slicer Connections".

Tips: When you have many Pivot Tables to share one slicer, the easy way is to set up the first, and copy to others, then change others' calculations.

Step 4: In the new window, find and check the "Region" slicer from the list.

Step 5: Click "OK" at the bottom, you will find the two Pivot Tables are all changing when clicking on the slicer.

Leave a Reply