In Excel 2000, How can I change the order in a pivot table?
 

I am having problems changing the order of my pivot table. The "Drop Column
Fields here" is date related and I grouped that area by month. I can change
the chart data series order, save the file, close the file, then reopen it
and the changes go back to the default view before the series order in the
chart changed. I have another co-worker that has Office 2003 and it does not
happen to her. It retains the information as she saved it. Is it a glitch in
Excel 2000?