Link/Connect a Single Slicer with Multiple Pivot Tables (2024)

Home / Pivot Table / Link/Connect a Single Slicer with Multiple Pivot Tables

Last Updated: June 21, 2023

Link/Connect a Single Slicer with Multiple Pivot Tables (1)

- Written by Puneet

Sometimes using more than one pivot table is a mess. But it’s not a mess if you connect all the pivot tables with a single slicer. So do you know how to link a slicer with multiple pivot tables?

If you don’t know then follow this post and you will learn a superb trick to create some interactive dashboards.

Yes, that’s right.

Let’s say you are working on a dashboard where you are using multiple pivot tables. If you are able to connect a slicer to all the pivot tables you can control the entire dashboard with a single slicer.

Link/Connect a Single Slicer with Multiple Pivot Tables (2)

In the above example, we have a single slicer to control both of the pivot tables.

NOTE: Pivot Tables are one of the INTERMEDIATE EXCEL SKILLS.

Steps to Connect a Slicer to Multiple Pivot Tables

Below are the steps which you need to follow to create a multi-linked slicer:

First of all, take two or more pivot tables to connect a slicer.
After that, select a cell in any of the pivot tables.
From here, go to Analyze → Filter → Insert Slicer.
Now from the “Insert Slicer” dialog box, select the column to use as a filter in the slicer and click OK.
At this point, you have a slicer in your worksheet which can filter the pivot table in which you insert it.
Next, you need to connect it to the second pivot table.
From here, select the slicer and go to Analyze → Slicer → Report Connections.
You will get a new dialog box with the list of pivot tables that are in your workbook.
In the end, just tick mark all the pivot tables and click OK.

Congratulations! You have connected the slicer with two pivot tables.

More on Pivot Tables

Refresh All Pivot Tables at Once
Group Dates in a Pivot Table
Pivot Table Timeline
Automatically Update a Pivot Table Range
Conditional Formatting to a Pivot Table
Running Total in a Pivot Table
Excel Slicer

37 thoughts on “Link/Connect a Single Slicer with Multiple Pivot Tables”

thanks a lot for this – grateful

Reply
I am using Office 2016
1. I created two pivot tables side by side similar to what you have in your tutorial
2. followed your steps above > This did not work
It keeps popping up just the other data table on another sheet that was used for this pivot table and the original data page and not the second pivot table on this sheet1 page. It does not find the secondary pivot table on the same sheet.
– they are created from different data sources, but have some similar information (Columns) that I wish to use as a slicer in both…. does not work.

Reply
The enable show PT data allows user by double clicking to see all the source data Fields in from source !, Is there a way that once you double click on PT, Only the Filtered result Data values fields Details to be shown to the PT user, by ignoring other row fields. Hope it clears to you. Example my source data has Salary for all employees, however don not want to show all columns to PT user

Reply
Hi, Developer, Greetings from Excel Enthusiast, How do I slice my Source Data table based on Pivot Table Slicer, or is there any way that I can connect a Structured (Source Table) Slicer to a PT slicer. Appreciate your assistance with code at email panstar5@yahoo.com thanks in advance Regards

Reply
This worked perfectly for my three pivot tables! Thank you.

Reply
See Also
Excel Timeline Tutorial + Free Template + Export to PPT Connect Slicer to Multiple Data Sources — Excel Dashboards VBA Updating Slicer Excel: Sharing a Pivot Table Slicer Between Multiple Data Sets | IMA
- What version of Excel / Office are you using? I have Office 2016 and this never worked!
  
  Reply
How many pivot tables can I connect with one slicer?
It seems that I can’t connect more than 5 tables.
Is there any alternative way for more than 5 pivot tables?

Reply
I like your approach for teaching excel skills – your narrative is clear and topics are well organized. Is there a simple way to apply a slicer/timeline to pivotreports with different pivotcaches derived from the same data table? I am using Excel 2016.

Reply
- thanks for your words, Drew. that’s may not be possible to do.
  
  Reply
In excel 2016
I have create 1 pivot table have only slicer data (Here is “Zone”). then report connection it to last 2 table

Reply
I have 4 pivot tables that do not share cash (since i need different grouping on them)
is there any way to connect across ?

Reply
Hi !
Thanks a lot for this orientation !

Pope

Reply
- You are welcome, Pope.
  
  Reply
Excel 2016: I have pivot data in 2 different sheets of the same workbook but not able to see the 2nd Pivot data when I click on ‘Report Connections’

Reply
- I have the same problem. It only shows the report connection for the same pivot table that the slicer was originally created from.
  
  Reply
  - Have You already solved this Problem? I’m at the Same Situation 🙁
    
    Reply
    See Also
    How To Create A Project Timeline In Excel (With Templates!) | ClickUp
Hi,

Is it possible in the report connection to link or unlink all available tables in one step instead of clicking every single table individually?

Reply
hi does the slice on excel 2016 work for more than 2 pivots?
i am unable to link to more than 2 pivots

Reply
Can you add the original data table to the post.

Reply
Hi Punnet, Can you share POWER BI tricks

Reply
Puneet, thanks for this post, it helped me out!
However, please pay attention to the fact that steps 7 and further are slightly different, at least in Office 365 ProPlus (Version 1907 (Build11901.20176))
The ribbon option is titled “Filter Connections” and then it lists existing slicers.
Tell me if you wish to receive printscreens.

Reply
- Yup send me.
  
  Reply
You instructions just did not work

Reply
- What went wrong?
  
  Reply
I liked very much, thanks

Reply
- You’re Welcome
  
  Reply
  - Hi Puneet,
    
    i am unable see the multiple pivot tables to give the connection to a single slicer
    
    can you help me in this issue.
    
    Reply
once I reached report connecter, the sheet showing only one

Reply
- Can I have a screenshot?
  
  Reply
The books are useful.

Thanks & Regards.

Reply
Hi Puneet
Many thanks for sharing how to link one single slicer to multiple pivot tables. Your instructions plus your Excel example file gave very clear instructions.
Regards, Victor

Reply
- I’m glad you liked it, Victor.
  
  Reply
Can we connect two Pivot Table of different sources but have one common Factor/Heading?
If Yes, How?

Reply
- Only when you create a pivot table through combining those two sources.
  
  Reply
  - Please explain with example and workbook.
    or share the link if already done.
    ———
    
    Reply
I am unable to go to Analyze.
Actually I could not find it.
Where it is?

Reply
- When you select a pivot, you’ll two extra tab on the ribbon. Try again.
  
  Reply

Link/Connect a Single Slicer with Multiple Pivot Tables (2024)

Steps to Connect a Slicer to Multiple Pivot Tables

More on Pivot Tables

37 thoughts on “Link/Connect a Single Slicer with Multiple Pivot Tables”

Leave a Comment