No, it's a setting that only affects the specific pivot table. All the
fields will be affected. To change it:

Right-click a cell in the pivot table, and click PivotTable Options
Click the Totals & Filters tab
Under Sorting, remove the check mark from Use Custom Lists when sorting,
then click OK.

malcomio wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html