Pivot Table out of order

R

reno

have data arranged in alphabetic order, by county. when i run the pivot
table 2 counties are out of alphabetic order. i have checked to make sure
there are no extra characters in the names (leading or trailing).
the counts the table show are correct but these two counties appear at the
top of the table out of order. have deleted the p-table and run 3 times with
same result??
thanks
reno
 
D

Debra Dalgleish

You may have a custom list that contains those counties, and custom
lists are sorted first.

To override this, you can select a cell in the field, and click the A-Z
button on the toolbar. (if prompted, confirm manual sorting)

Or, delete the custom list:
Choose Tools>Options
 
R

reno

Thanks, I do have a custom listing of states but not counties, however, Iowa
and Washington are WI counties as well as states. Another hidden anamoly in
XL.
 
Top