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) / PivotTable Connections (Excel 2010) option within the Slicer. Â This is how it is achieved:

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” thePivotTable2 box and press OK

STEP 5:Right Click on Slicer #2 and go to Report Connections(Excel 2013)/PivotTable Connections (Excel 2010) >“check” thePivotTable1Â 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:

VIEW THIS EXCEL PIVOT TABLE SLICER TUTORIALÂ ON OUR YOUTUBE CHANNEL:Â

Errors When Grouping By Dates With Excel Pivot Tab... In our Group By DateÂ post, we grouped our sales numbers byÂ weeks.
HoweverÂ there are times when we try to group by Dates and weÂ get an error message! Â That is frustrating!
Instead of checking the dates one by one to find out where the error occurred, I will show you a cool w...

Distinct or Unique Count with Excel Pivot Tables Excel 2013 added some new features to its arsenal and one that has been well overdueÂ was the distinct or unique count.
Previously when we created a Pivot Table and dropped a Customers field in the Row Labels and then again in the Values area we got theÂ "total number of transac...

Pivot Charts & Slicers In a previous post I showed you how to Insert a Pivot Chart.Â Now we will take this concept once step further and insert a Slicer.Â The cool thing about this is that the Slicer will control both the Pivot Table and the Pivot Chart.
See how you can start creating some awesome i...

Show Report Filter Pages in a Pivot Table When you are using an Excel Pivot Table you can show the items within the Report Filter on separate sheets inside your workbook.
Say that you have created an awesome Pivot Table which shows total sales and number of transactions per region.
You can drop in your Customer fie...

DO YOU WANT TO GET BETTER AT EXCEL?
If so, join over 80,000 professionals who get career boosting, Free Excel lessons delivered on a weekly basis & receive our Free Excel Keyboard Shortcuts Template

Let me know if you have any questions, Iâ€™m here to help ?

John

Dear recipient
I have passed time unsuccessfully to find a way to filter a field in a pivot report according to a list of values
For example pivot report includes all vailable product codes but need to see info only for a few items. The choice is to select the wanted items manually throught field filter or slicer.
IS THERE ANY OPTION TO APPLY FILTER AUTOMATICALY ACCORDING TO A LIST OF PRODUCTS IN AN EXCEL FILE???

Actually, I think there is a limit unless you’re using Excel 2016 or higher. I can’t connect more than 4 pivot tables in Excel 2013…

Hey Derek,

You can connect more than 4 Pivot Tables in Excel 2010 and onwards.

I have connected more than 10 Pivot Tables with one Slicer.

Cheers,
John

I’m using the MS 2016 trial version, after creating the slicers, I want to connect them with other pivot table, however, when choosing the Report Connections there is only one Pivot table equivalent with that sheet shown up. Is that because of the trial version?
Thank you!

Unfortunately this can only be done if the list in another sheet is part of the Pivot Table data.

Thanks,
John

I have followed the steps as described, but only the pivot table the slicer is connected to, is shown in the report connection box. So I cannot select the other pivot table. Any suggestions ?

Fantastic … i noticed it even works without creating the slicer for the other pivot table … which means that a worksheet with multiple pivots could potentially have one tab with slicers and have ALL tabs act as slaves.

As long as the Pivot Tables come from the same data source, you can create multiple Slicers and connect them to all the Slicers…the fun has just started ðŸ™‚

Cheers,
John

Is there any way to auto-connect multi-slicers all at once ? any plug-in or tricks….pls. Thank you

As Slicers are their own separate objects you will need to select each one, right click and choose the Report Connections.

In Excel 2013, there is a Report Connections button in the Slicer Tools ribbon, so you can easily access this option from here.