Mar 09 2022 07:22 PM
Why is the slicer option for my pivot table greyed out.
Mar 09 2022 11:27 PM - edited Mar 09 2022 11:29 PM
@farias1100 A quick Google search tells me that this happens when you are using an xls file. Save it as an xlsx workbook. Close and re-open and the slicer option should become available to you.