Jun 05 2020 02:23 PM
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?
Jun 05 2020 04:10 PM
Jun 05 2020 11:25 PM
@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.
Save your workbook as type "Excel Workbook (.xlsx)". Close and re-open. Then the slicer buttons should work.