How to connect a single slicer to multiple pivot tables in excel.

The use of more than one pivot table can be messy.If you connect all the pivot tables with a single slicer, it won't be a problem.Do you know how to link a slicer with multiple pivot tables?

If you follow this post, you will learn a great trick to create interactive dashboards.

You can control the entire dashboard with a single slicer if you connect a slicer to all the pivot tables.

One of the INTERMEDIATE EXCEL SKILLS is the pivot table tip.

When I have to work on dashboards, I like to link a slicer to multiple pivot tables.You cannot connect a slicer with more than one pivot table.

Please don't forget to share this tip with your friends if you share your views with me in the comment section.

Since his college days,Puneet has been using excel.He taught thousands of people how to use spreadsheets and Microsoft excel.He can be found online, on a running track or hiking up a mountain.

Your narrative is clear and the topics are organized.Is it possible to apply a slicer/timeline to pivotreports with different pivotcaches from the same data table?I am using a spreadsheet.

I created 1 pivot table with slicer data in excel.Then report the connection to the last table.

Is there a way to connect the pivot tables that don't share cash?

I have pivot data in 2 different sheets of the same workbook, but not able to see the second one when I click on the report connection.

Is it possible to unlink all available tables in one step, instead of clicking every single table individually?

Does the slice on excel work for more than 2 pivots?I can't link to more than 2 pivots.

Thanks for the 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.Let me know if you would like to receive printscreens.

Thanks for sharing how to link one slicer to multiple pivot tables.Very clear instructions were given by your instructions and your example file.Thank you, Victor.