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
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.
In above example, I am using a single slicer to control both of the pivot tables.
Just follow these simple steps to insert a multi-linked slicer in pivot tables.
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.