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??

Slicer Connection Greyed Out

There are two things that can cause your Slicer connection to be greyed out!

ONE: Your file format is in an older/incompatible format (e.g. an .xls file extension)

TWO: You can see the text [Compatibility Mode] right beside the name of your excel file:

Slicer Connection Greyed Out

Let me show you quickly how you can resolve this problem in just a few steps!

DOWNLOAD EXCEL WORKBOOK

STEP 1: Go to File > Convert

Slicer Connection Greyed Out

Slicer Connection Greyed Out

 

STEP 2: This will convert your Excel file into a more updated version.

Click OK.

Slicer Connection Option Greyed Out For Excel Pivot Table

Click Yes to reload your workbook.

Slicer Connection Option Greyed Out For Excel Pivot Table

 

Voila! You can now insert your slicer!

NB: You can also Save As your current file as an .XLSX file format.  Then close this file and open it again and you will be able to use the Slicer button again!

Slicer Connection Option Greyed Out For Excel Pivot Table

 

HOW TO ENABLE THE GREYED OUT SLIDER CONNECTION

Slicer Connection Option Greyed Out For Excel Pivot Table

Helpful Resource:

Free Excel Pivot Table Online Training Course

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Show & Hide Field List in Excel Pivot Table Have you ever had the scenario where you are working on your Pivot Table and the Field List disappears?Lots of Excel users get annoyed with this but luckily I'm here to help you out 🙂If your Pivot Table Field List disappears, you can easily bring it back as I show you be...
Group By Half Years With Excel Pivot Tables  In our previous post, we were able to Group by Month using Pivot Tables.  Let us take it up another notch, and group it by Half Years!In the example below I show you how to get the Sales Grouped by Half Years: January to June and July to December DOWNL...
Count VS Sum in Pivot Tables The #1 complaint that I get from Pivot Tables is "Why do my values show as a Count of rather than a Sumof ?"Well there are three reasons why this is the case:1. There are blank cells in your values column within your data set; or2. There are "text" cells in your value...
Show The Percent of Row Total With Excel Pivot Tab... Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF ROW TOTAL calculation.This option will immediately calculate the percentages for you from a table filled with numbers such as sales data, exp...