Forum Discussion
Andy_Carden
Oct 04, 2022Copper Contributor
Insert Slicer
Trying to setup a slicer option in a table, not a pivot table and it is grayed out. Sheet is not protected what would cause this option to not be available?
Andy_Carden
Oct 05, 2022Copper Contributor
Martin_Weiss Thank you for the quick response, I am using Excel on a Mac, most current version.
Martin_Weiss
Oct 05, 2022Bronze Contributor
Hi Andy_Carden
ok, if the sheet is not protected, there is only thing I can think of:
Is the workbook saved in the old XLS format? This also would make slicers unavailable.