I have a pivot table which works well. I have it sirted by field 3 lets say.
But when I go to a drop down on another field, the list is not in
alphabetical order. Does anyone know how to sort this without affecting the
whole of the table.

Thanks
Alan
Fife
Scotland