**Want to know how to Connect Slicers to Multiple Excel Pivot Tables?**

**Want to know how to Connect Slicers to Multiple Excel Pivot Tables?**

*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***

**Watch on YouTube**and give it a thumbs up 👍

**Pivot Table Slicers** were first introduced in Excel 2010 for Windows and Excel 2016 for Mac.

They are a visual filter in the form of anÂ interactive button. Â There are several cool things that you can do with Slicers, like customize them, filter them and connect them to multiple Pivot Tables.

The coolest thing that you can do is to **connect Slicers to multiple Excel Pivot Tables**. Â I explain how you can easily do this below…(scroll further down to watch our YouTube instructional video!)

Normally when you insert an Excel Slicer it is **only connected to the Pivot Table that you are inserting it from**.

What about if you had **multiple Pivot Tables** from the same data set and wantedÂ to connect a Slicer to all of the Pivot Tables, so when you press a button all the Pivot Tables change?

Well this is possible with the Report Connections (Excel 2013 & 2016 & 2019) / PivotTable Connections (Excel 2010) option within the Slicer.

**STEP 1:** **Create 2Â Pivot Tables** by clicking in your data set and selecting *Insert > Pivot Table > New Worksheet/Existing Worksheet*

**Setup Pivot Table #1:**

**ROWS:** Region

**VALUES:** Sum of Sales

**Setup Pivot Table #2:**

**ROWS:**Â Customer

**VALUES:** Sum of Sales

**STEP 2:** **Click in Pivot Table #1 and insert a MONTH Slicer** by going to *PivotTable Tools > Analyze/Options > Insert Slicer > Month > OK*

**STEP 3:**Â **Click in Pivot Table #2 and insert a YEAR Slicer** by going to *PivotTable Tools > Analyze/Options > Insert Slicer > Year > OK*

**STEP 4:** **Right Click on Slicer #1** and go to *Report Connections(Excel 2013 & 2016)/PivotTable Connections (Excel 2010) >* *“check”* the** PivotTable2 box** and press

**OK**

**STEP 5:** **Right Click on Slicer #2** and go to *Report Connections(Excel 2013)/PivotTable Connections (Excel 2010) >* *“check”* the** PivotTable1Â box** and press

**OK**

Now as you select each Slicer’s items, both Pivot Tables will change!

Have a look at the following image and the tutorial below that to seeÂ how this is achieved using Excel 2013: