Slicer

Occasional Visitor

Why is the slicer option for my pivot table greyed out. 

1 Reply

@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.