Pinterest Pixel

Slicer Connection Option Greyed Out For Excel Pivot Table

Sometimes when you create a Pivot Table and want to insert a Slicer you are unable to... read more

Download Excel Workbook
Bryan
Posted on

Overview

Slicer Connection Option Greyed Out For Excel Pivot Table | MyExcelOnline Slicer Connection Option Greyed Out For Excel Pivot Table | MyExcelOnline

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 Option Greyed Out For Excel Pivot Table

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 Option Greyed Out For Excel Pivot Table

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

Slicer Connection Option Greyed Out For Excel Pivot Table | MyExcelOnline

Download excel workbookSlicer-Connection-Greyed-Out.xls

STEP 1: Go to File > Convert

Slicer Connection Option Greyed Out For Excel Pivot Table

Slicer Connection Option Greyed Out For Excel Pivot Table

 

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

 

Further Learning:

 

Helpful Resource:

Slicer Connection Option Greyed Out For Excel Pivot Table

 

If you like this Excel tip, please share it
Slicer Connection Option Greyed Out For Excel Pivot Table | MyExcelOnline Slicer Connection Option Greyed Out For Excel Pivot Table | MyExcelOnline
Slicer Connection Option Greyed Out For Excel Pivot Table | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  How to Lock the Excel Pivot Table | A Detailed Tutorial

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...