Right-click on the field button for the unsorted list.
Click on Field Settings
Click Advanced
For AutoSort Options, click on Ascending
Click OK, click OK

Alan B wrote:
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.

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html