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.

10000+ Copies Already Downloaded

A Single Slicer To Filter Multiple Pivot Tables

how to connect slingle 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. And, you will learn a superb trick to create some interactive dashboards.

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.

 Link Slicer To Multiple Pivot Tables

In above example, I am using a single slicer to control both of the pivot tables.

Instant Access: Download this Cheat Sheet to learn these steps to connect a slicer to multiple pivot tables.

Steps To Link Slicer To Multiple Pivot Tables In Excel

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

  • Take two or more pivot tables to connect a slicer.

Add Two Pivot Tables To Link Slicer To Multiple Pivot Tables

  • Select a cell in any of the pivot-table.
  • 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. Click OK.

Click OK To Link Slicer To Multiple Pivot Tables In Excel

  • At this point, you have a slicer in your worksheet which can filter the pivot table in which you insert it.

Click On Report Connections To Link Slicer To Multiple Pivot Tables

  • Now, select the slicer & 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.

Tick Mark Both Pivot Tables o Link Slicer To Multiple Pivot Tables

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

Add Two Pivot Tables To Link Slicer To Multiple Pivot Tables

Important Point

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

Sample File

download sample excel file

Conclusion

I love to link a slicer to multiple pivot tables when I have to work on dashboards. What do you think? Do you like this tip? Have you ever done this before? Tell me in the comment box.

More Tips