You can manually rearrange the columns, if manual sort is on. Or, create
a custom list, and the pivot table will sort in that order:

Type the list on the worksheet
Select the list
Choose ToolsOptions
Select the Custom List tab
Click the Import button
Click OK

plato wrote:
Is it possible to change the column order in pivot tables or do I need to
change the column names of the raw data into alphabetical or numerical order
and then change them back?

plato




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html