Excel Champs Blog

    Excel Productivity Guide
    Useful Excel Tips | Keyboard Shortcuts | VBA Codes
    Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

    Worth $20, Absolutely Free

    How to Link/Connect a Single Slicer with Multiple Pivot Tables in Excel

    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. You will learn a superb trick to create some interactive dashboards.

    Alright.

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

    connect single slicer with multiple pivot tables

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

    Steps to Link/Connect Slicer to Multiple Pivot Tables in Excel

    Just follow these simple steps to insert a multi-linked slicer in pivot tables.

    • First of all, take two or more pivot tables to connect a slicer.
    two pivot tables to connect with a single slicer
    • After that, select a cell in any of the pivot-table and Go to Analyze → Filter → Insert Slicer.
    • Now, you will get Insert Slicer dialog box. Select the column to use as a filter in the slicer and click OK.
    click on column heading to insert a slicer and connect with all the pivot table
    • At this point, you have a slicer in your worksheet which can filter the pivot table in which you insert it.
    click on report connection to insert a slicer which you can connect with all the pivot tables
    • 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 which are in your workbook. Just tick mark all the pivot tables and click OK.
    select all the pivots which need to connect with the slicer

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

    Important: You can only connect a slicer with more than one pivot table using the same data source.

    Sample File

    Download this sample file from here to learn more

    I love to link a slicer to multiple pivot tables when I have to work on dashboards.

    What do you thing? Do you like this tip?

    Share your views with me in the comment section, I'd love to hear from you. And, please don't forget to share this tip with your friends.

    Share0
    Tweet0

    Must Read Pivot Table Tips

    1. The Top 3 Methods To Automatically Update Pivot Table Range
    2. How to Apply Conditional Formatting to a Pivot Table
    3. How to Group Dates in a Pivot Table By [Year, Quarter, Month, and Time]
    4. How to Create a Pivot Table from Multiple Worksheets
    5. 5 Simple Steps to Insert a Pivot Table Timeline to Filter Dates
    • Vikas G

      I am unable to go to Analyze.
      Actually I could not find it.
      Where it is?

      • Puneet Gogia

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

    • Vikas G

      Can we connect two Pivot Table of different sources but have one common Factor/Heading?
      If Yes, How?

      • Puneet Gogia

        Only when you create a pivot table through combining those two sources.

        • Vikas G

          Please explain with example and workbook.
          or share the link if already done.
          ———

    • Victor

      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

      • Puneet Gogia

        I’m glad you liked it, Victor.