Thanks Debra, but manually sorting the pivot table doesn't do it either.

This is in Excel 2007, but using compatibility mode because I'm sending the
report to someone who uses Excel 2003.

Where is the option to turn off the custom lists? I can't find it anywhere.
Also would that mean that I couldn't autofill when I need to write a list of
months?