{"id":9149,"date":"2018-08-10T13:37:52","date_gmt":"2018-08-10T11:37:52","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=9149"},"modified":"2024-02-06T15:47:27","modified_gmt":"2024-02-06T14:47:27","slug":"slicer-connection-option-greyed-out-for-excel-pivot-table","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/slicer-connection-option-greyed-out-for-excel-pivot-table\/","title":{"rendered":"Slicer Connection Option Greyed Out For Excel Pivot Table"},"content":{"rendered":"<p>Sometimes when you create a <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> and want to insert a Slicer you are unable to do this as the Slicer button is greyed.<\/p>\n<p>You try to click on the Slicer button but nothing happens.<\/p>\n<p>What gives??<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Slicer Connection Option Greyed Out For Excel Pivot Table\"  class=\"alignnone size-full wp-image-9151\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-01.jpg\" alt=\"Slicer Connection Option Greyed Out For Excel Pivot Table\" width=\"994\" height=\"146\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-01.jpg 994w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-01-300x44.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-01-768x113.jpg 768w\" sizes=\"(max-width: 994px) 100vw, 994px\" \/><\/a><\/p>\n<p>There are two things that can cause your Slicer connection to be greyed out!<\/p>\n<p><strong>ONE:<\/strong> Your file format is in an <strong>older\/incompatible format<\/strong> (e.g. an <em><strong>.xls<\/strong><\/em> file extension)<\/p>\n<p><strong>TWO:<\/strong> You can see the text <strong>[Compatibility Mode]\u00a0<\/strong>right beside the name of your excel file:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Slicer Connection Option Greyed Out For Excel Pivot Table\"  class=\"alignnone size-full wp-image-9152\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-02.jpg\" alt=\"Slicer Connection Option Greyed Out For Excel Pivot Table\" width=\"427\" height=\"50\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-02.jpg 427w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-02-300x35.jpg 300w\" sizes=\"(max-width: 427px) 100vw, 427px\" \/><\/a><\/p>\n\n<p>Let me show you quickly how you can resolve this problem in just a few steps!<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/UANSf-jbhqQ?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out.xls\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out.xls\" 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-Connection-Greyed-Out.xls<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span>\u00a0Go to\u00a0<strong>File &gt; Convert<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Slicer Connection Option Greyed Out For Excel Pivot Table\"  class=\"alignnone size-full wp-image-9153\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-03.jpg\" alt=\"Slicer Connection Option Greyed Out For Excel Pivot Table\" width=\"332\" height=\"164\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-03.jpg 332w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-03-300x148.jpg 300w\" sizes=\"(max-width: 332px) 100vw, 332px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Slicer Connection Option Greyed Out For Excel Pivot Table\"  class=\"alignnone size-full wp-image-9154\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-04.jpg\" alt=\"Slicer Connection Option Greyed Out For Excel Pivot Table\" width=\"626\" height=\"231\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-04.jpg 626w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-04-300x111.jpg 300w\" sizes=\"(max-width: 626px) 100vw, 626px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> This will convert your Excel file into a more updated version.<\/p>\n<p>Click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-05.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Slicer Connection Option Greyed Out For Excel Pivot Table\"  class=\"alignnone size-full wp-image-9155\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-05.jpg\" alt=\"Slicer Connection Option Greyed Out For Excel Pivot Table\" width=\"762\" height=\"143\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-05.jpg 762w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-05-300x56.jpg 300w\" sizes=\"(max-width: 762px) 100vw, 762px\" \/><\/a><\/p>\n<p>Click\u00a0<strong>Yes\u00a0<\/strong>to reload your workbook.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-06.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Slicer Connection Option Greyed Out For Excel Pivot Table\"  class=\"alignnone size-full wp-image-9156\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-06.jpg\" alt=\"Slicer Connection Option Greyed Out For Excel Pivot Table\" width=\"827\" height=\"115\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-06.jpg 827w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-06-300x42.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-06-768x107.jpg 768w\" sizes=\"(max-width: 827px) 100vw, 827px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Voila! You can now insert your slicer!<\/p>\n<p><strong>NB:<\/strong> You can also <strong>Save As<\/strong> your current file as an <strong>.XLSX<\/strong> file format.\u00a0 Then close this file and open it again and you will be able to use the Slicer button again!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-07.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Slicer Connection Option Greyed Out For Excel Pivot Table\"  class=\"alignnone size-full wp-image-9157\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-07.jpg\" alt=\"Slicer Connection Option Greyed Out For Excel Pivot Table\" width=\"969\" height=\"492\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-07.jpg 969w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-07-300x152.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Slicer-Connection-Greyed-Out-07-768x390.jpg 768w\" sizes=\"(max-width: 969px) 100vw, 969px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-one-slicer-for-two-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Use One Slicer for Two Excel Pivot Tables<\/a><\/li>\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\/timeline-slicers-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Timeline Slicers In Microsoft Excel<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><strong>Helpful Resource:<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"Slicer Connection Option Greyed Out For Excel Pivot Table\"  class=\"alignnone wp-image-9214 size-large\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/08\/Blog_image_title_PIVOT_TABLES-1-1024x683.jpg\" alt=\"Slicer Connection Option Greyed Out For Excel Pivot Table\" width=\"1024\" height=\"683\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/08\/Blog_image_title_PIVOT_TABLES-1-1024x683.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/08\/Blog_image_title_PIVOT_TABLES-1-300x200.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/08\/Blog_image_title_PIVOT_TABLES-1-768x512.jpg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/08\/Blog_image_title_PIVOT_TABLES-1.jpg 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes when you create a Pivot Table and want to insert a Slicer you are unable to do this as the Slicer button is greyed. You try to click on the Slicer button but nothing happens. What gives?? There are two things that can cause your Slicer connection to be greyed out! ONE: Your file [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17181,"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":[4,23],"tags":[139,466],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/9149"}],"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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=9149"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/9149\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17181"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=9149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=9149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=9149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}