Hi,
Using Excel 2007

For some reason my Pivot Table Field List selection under "Choose fields to
add to report:" is sorted in ascending order and not in the order they appear
in the data. This means that the data dates are sorted by month by year and
not by year by month.

e.g.
Sum of 1 Apr 2009
Sum of 1 Apr 2010
Sum of 1 Apr 2011
Sum of 1 Aug 2009
Sum of 1 Aug 2010
Sum of 1 Aug 2011
Sum of 1 Dec 2009
Sum of 1 Dec 2010
etc
instead of
Sum of 1 Apr 2009
Sum of 1 May 2009
Sum of 1 Jun 2009
etc.

This makes selecting contiguous months REALLY tedious!! What have I done??
Any suggestions appreciated!
Regards,
Bony