Hi,

I am using Excel 2003 and have three types of Work in my Pivot Table:

Erect
Alter
Dismantle

This work type is my outer row in my pivot table but it is sorted in
alphabetical order. I would like my data to be sorted as above. I know that
I can drag them around but I have a macro that updates the Pivot Table based
on an Advanced Filter. Is there anyway I can fix in place the non
alphabetical sort order?

Thank you