{"id":1869,"date":"2020-07-09T16:25:30","date_gmt":"2020-07-09T14:25:30","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1869"},"modified":"2024-03-22T19:02:52","modified_gmt":"2024-03-22T18:02:52","slug":"connect-slicers-to-multiple-excel-pivot-tables","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/connect-slicers-to-multiple-excel-pivot-tables\/","title":{"rendered":"Connect Slicers to Multiple Excel Pivot Tables"},"content":{"rendered":"<p>When you insert an <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Excel Pivot Table<\/a> Slicer it is <strong>only connected to the Pivot Table that you are inserting it from<\/strong>.<\/p>\n<h3>What about if you had <strong>multiple Pivot Tables<\/strong> from the same data set and wanted to add <strong>Slicer to Pivot Table<\/strong>, so when you press a button all the Pivot Tables change?<\/h3>\n<p>Well this is possible with the Report Connections (<em>Excel 2013, 2016, 2019 &amp; Office 365<\/em>) \/ PivotTable Connections (Excel 2010) option within the Slicer.<\/p>\n<p>The coolest thing that you can do is to <strong>connect slicer to multiple Pivot Tables<\/strong>. I explain how you can easily do this below&#8230;<\/p>\n<style>.special-box a { color: #fff; } <\/style><div class=\"drop-shadow lifted special-box\" style=\"text-align: center; color: #fff; padding: 15px; background: var(--V4-primary-orange); border-radius: 6px;\"> <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\">&#x1f449; Click Here To Join Our FREE Excel Pivot Tables &amp; Excel Dashboards Webinar That Will SAVE YOU HOURS At Work &amp; INCREASE Your Excel SKILLS!<\/a><\/strong> <\/div>\n<h3><em><strong>Connect Slicers to Multiple Excel Pivot Tables In 5 Steps&#8230;<\/strong><\/em><\/h3>\n\n<hr \/>\n<p>&nbsp;<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Slicer-Connections.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Slicer-Connections.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Slicer-Connections.xlsx<\/span><\/a><\/p>\n<\/div>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/connect-slicers-to-multiple-excel-pivot-tables\/#Step_By_Step_Guide\" title=\"Step By Step Guide\">Step By Step Guide<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/connect-slicers-to-multiple-excel-pivot-tables\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Step_By_Step_Guide\"><\/span><span style=\"color: #ff6600;\"><strong>Step By Step Guide<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Follow the step-by-step tutorial on How to link slicer to multiple Pivot tables in Excel:<\/p>\n<div class=\"jumbotron2\">\n<div class=\"meo-subcount-2\">\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> <strong>Create 2\u00a0Pivot Tables<\/strong> by clicking in your data set and selecting <strong><em>Insert &gt; Pivot Table &gt; New Worksheet\/Existing Worksheet<\/em><\/strong><\/p>\n<h3><span style=\"color: #0000ff;\"><strong>Setup Pivot Table #1:<\/strong><\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-01-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5117\" title=\"Connect Slicers to Multiple Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-01-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"392\" height=\"333\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-01-1.png 392w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-01-1-300x255.png 300w\" sizes=\"(max-width: 392px) 100vw, 392px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>ROWS:<\/strong> Region<\/p>\n<p><strong>VALUES:<\/strong> Sum of Sales<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-02-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5118\" title=\"Connect Slicers to Multiple Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-02-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"219\" height=\"264\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #0000ff;\"><strong>Setup Pivot Table #2:<\/strong><\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-03-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5119\" title=\"Connect Slicers to Multiple Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-03-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"400\" height=\"336\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-03-1.png 400w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-03-1-300x252.png 300w\" sizes=\"(max-width: 400px) 100vw, 400px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>ROWS:<\/strong>\u00a0Customer<\/p>\n<p><strong>VALUES:<\/strong> Sum of Sales<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-04-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5120\" title=\"Connect Slicers to Multiple Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-04-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"239\" height=\"279\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> <strong>Click in Pivot Table #1 and insert a MONTH Slicer<\/strong> by going to <strong><em>PivotTable Tools &gt; Analyze\/Options &gt; Insert Slicer &gt; Month &gt; OK<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-05-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5121\" title=\"Connect Slicers to Multiple Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-05-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"530\" height=\"547\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-05-1.png 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-05-1-291x300.png 291w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-06-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5122\" title=\"Connect Slicers to Multiple Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-06-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"460\" height=\"485\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-06-1.png 460w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-06-1-285x300.png 285w\" sizes=\"(max-width: 460px) 100vw, 460px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span>\u00a0<strong>Click in Pivot Table #2 and insert a YEAR Slicer<\/strong> by going to <strong><em>PivotTable Tools &gt; Analyze\/Options &gt; Insert Slicer &gt; Year &gt; OK<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-07-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5123\" title=\"Connect Slicers to Multiple Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-07-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"506\" height=\"551\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-07-1.png 506w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-07-1-275x300.png 275w\" sizes=\"(max-width: 506px) 100vw, 506px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-08-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5124\" title=\"Connect Slicers to Multiple Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-08-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"268\" height=\"208\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> <strong>Right Click on Slicer #1<\/strong> and go to <em>Report Connections(Excel 2013, 2016, 2019 &amp; Office 365)\/PivotTable Connections (Excel 2010) &gt;<\/em> <strong><em>&#8220;check&#8221;<\/em> the<\/strong> <strong><em>PivotTable2<\/em> box<\/strong> and press <strong>OK<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-09.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4629\" title=\"Connect Slicers to Multiple Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-09.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"437\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-09.png 437w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-09-291x300.png 291w\" sizes=\"(max-width: 437px) 100vw, 437px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-10-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5125\" title=\"Connect Slicers to Multiple Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-10-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"373\" height=\"212\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-10-1.png 373w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-10-1-300x171.png 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> <strong>Right Click on Slicer #2<\/strong> and go to <em>Report Connections(Excel 2013, 2016, 2019 &amp; Office 365)\/PivotTable Connections (Excel 2010) &gt;<\/em> <strong><em>&#8220;check&#8221;<\/em> the<\/strong> <strong><em>PivotTable1<\/em>\u00a0box<\/strong> and press <strong>OK<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4631\" title=\"Connect Slicers to Multiple Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-11.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"289\" height=\"449\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-11.png 289w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-11-193x300.png 193w\" sizes=\"(max-width: 289px) 100vw, 289px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4632\" title=\"Connect Slicers to Multiple Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-12.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"384\" height=\"212\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-12.png 384w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-12-300x166.png 300w\" sizes=\"(max-width: 384px) 100vw, 384px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Now as you select each Slicer&#8217;s items, both Pivot Tables will change!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/2015-11-03_15-54-54.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1880\" title=\"Connect Slicers to Multiple Excel Pivot Tables\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/2015-11-03_15-54-54.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"656\" height=\"619\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/2015-11-03_15-54-54.png 656w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/2015-11-03_15-54-54-300x283.png 300w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><span style=\"color: #ff6600;\"><strong>Conclusion<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>Further learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ultimate-guide-excel-pivot-table-slicers\/\" target=\"_blank\" rel=\"noopener\">The Ultimate Guide to Excel Pivot Table Slicers<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-table-slicers\/\" target=\"_blank\" rel=\"noopener\">Excel Table Slicers<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pivot-charts-slicers\/\" target=\"_blank\" rel=\"noopener\">Pivot Charts &amp; Slicers<\/a><\/li>\n<\/ul>\n<div class=\"after-post-box\"><style>.special-box a { color: #fff; } <\/style><div class=\"drop-shadow lifted special-box\" style=\"text-align: center; color: #fff; padding: 15px; background: var(--V4-primary-orange); border-radius: 6px;\"> <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\">&#x1f449; Click Here To Join Our FREE Excel Pivot Tables &amp; Excel Dashboards Webinar That Will SAVE YOU HOURS At Work &amp; INCREASE Your Excel SKILLS!<\/a><\/strong> <\/div><\/div>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you insert an Excel Pivot Table Slicer it is only connected to the Pivot Table that you are inserting it from. What about if you had multiple Pivot Tables from the same data set and wanted to add Slicer to Pivot Table, so when you press a button all the Pivot Tables change? Well [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":18625,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[23,4],"tags":[86,92],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1869"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=1869"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1869\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/18625"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}