Link/Connect a Single Slicer with Multiple Pivot Tables

HomePivot TableLink/Connect a Single Slicer with Multiple Pivot Tables

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.

connect single slicer with multiple pivot tables

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:

  1. First of all, take two or more pivot tables to connect a slicer.
  2. After that, select a cell in any of the pivot tables.
  3. From here, go to Analyze → Filter → Insert Slicer.
  4. Now from the “Insert Slicer” dialog box, select the column to use as a filter in the slicer and click OK.
  5. At this point, you have a slicer in your worksheet which can filter the pivot table in which you insert it.
  6. Next, you need to connect it to the second pivot table.
  7. From here, select the slicer and go to Analyze → Slicer → Report Connections.
  8. You will get a new dialog box with the list of pivot tables that are in your workbook.
  9. 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

30 thoughts

Leave a Comment

Your email address will not be published.

  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. hi does the slice on excel 2016 work for more than 2 pivots?
    i am unable to link to more than 2 pivots

    Reply
  7. 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
  8. 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