Creating Slicers in Excel 2020 for Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-1444092%22%20slang%3D%22en-US%22%3ECreating%20Slicers%20in%20Excel%202020%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1444092%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20small%20pivot%20table%20in%20the%20Excel%20for%20Mac%202020%20version%20and%20would%20like%20to%20add%20slicers.%26nbsp%3B%20Unfortunately%20the%20slicer%20button%20is%20greyed%20out%20no%20matter%20what%20cell%20I%20select%20within%20the%20pivot%20table.%26nbsp%3B%20How%20do%20I%20turn%20this%20option%20on%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1444092%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1444239%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Slicers%20in%20Excel%202020%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1444239%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20use%20the%20Slicer%20in%20Mac%2C%20you've%20got%20to%20select%20your%20data%20and%20click%20on%20Slicer%20from%20the%20contextual%20ribbon%20tab.%3CBR%20%2F%3E%3CBR%20%2F%3EDo%20see%20the%20short%20video%20below%20to%20guide%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fyoutube.com%2Fwatch%3Fv%3DVfk0H481X7w%26amp%3Bt%3D1s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutube.com%2Fwatch%3Fv%3DVfk0H481X7w%26amp%3Bt%3D1s%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have created a small pivot table in the Excel for Mac 2020 version and would like to add slicers.  Unfortunately the slicer button is greyed out no matter what cell I select within the pivot table.  How do I turn this option on?

2 Replies
Highlighted
Hello,

To use the Slicer in Mac, you've got to select your data and click on Slicer from the contextual ribbon tab.

Do see the short video below to guide

https://youtube.com/watch?v=Vfk0H481X7w&t=1s
Highlighted

@JLCantor Could replicate the situation if I saved the file as .xls (i.e. old Excel file type). The fie will open in 'compatibility mode' but the slicer buttons are greyed out.

Screenshot 2020-06-06 at 08.18.16.png

Save your workbook as type "Excel Workbook (.xlsx)". Close and re-open. Then the slicer buttons should work.

Screenshot 2020-06-06 at 08.21.23.png