No prob, John. Glad you found the way to do it. I guess the pivot sorting
feature was enhanced in xl2003.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"John Calder" wrote in message
...
Max
I fixed the probelm. The column I was trying to sort was the 2nd column on
the pivot table. I switched this column with column 1 and now it sorts ok.
Its seems it only likes the data in the pivot table to be sorted by the
1st
column of the table.
Thanks for your help