Two items in pivot table not sorting properly

In the attached workbook, the Team field in the pivot table sorts correctly alphabetically except for MON and SEP. I've tried various things to no avail. This really has me baffled.

Ken S.

From Contextures:
Right-click a cell in the pivot table, and click PivotTable Options.
In the PivotTable Options dialog box, click the Totals & Filters tab.
In the Sorting section, remove the check mark from "Use Custom Lists When Sorting"

Pete

Originally Posted by PeteABC123

From Contextures:
Right-click a cell in the pivot table, and click PivotTable Options.
In the PivotTable Options dialog box, click the Totals & Filters tab.
In the Sorting section, remove the check mark from "Use Custom Lists When Sorting"

Pete

Thanks, but looks like this is for a later version than I have, using Excel 97. I know it's ancient but works pretty well for what I want to do.

Ken

I fixed this by adding a custom list with all the teams in correct order. Still don't know this got messed up.

Ken