Pivot table sorting problem

  • Thread starter Thread starter Greg Rivet
  • Start date Start date
G

Greg Rivet

I have a pivot table, that in the row field has last name, which I can't get
to sort alphabetically. The first nine names remain fixed and the balance do
sort alpha. If I switch the sort to descending the nine go to the bottom and
the rest sort as expected. The table from which the PT is created, the names
are sorted Alpha. I've checked for hidden characters, the formating of the
cells, changed it from general to text and back again. Nothing seems to
work. Anybody got a clue? TIA

Greg
 
I'm having a similar problem with Autosort in a Pivottable

My data is a list of 3-letter airport codes, "SAT" (San Antonio) among them

Excel in it's infinite wisdom apparently thinks "SAT" means "Saturday", i.e., a day of the week, and sorts SAT to the top of my list, before ABE, ABQ, ALB, etc. The same thing happens if I have "JAN" in the list, which Excel interprets as "January" instead of just leaving it alone

I can fix it by manually moving SAT or JAN to where it should be, but I don't think I should have to do this every time. If I sort the same list just in an Excel spreadsheet, it sorts the correct way

Are the 9 last names you're having trouble with by any chance month names? days of the week? anything that Excel could classify as anything else

Mik

----- Greg Rivet wrote: ----

I have a pivot table, that in the row field has last name, which I can't ge
to sort alphabetically. The first nine names remain fixed and the balance d
sort alpha. If I switch the sort to descending the nine go to the bottom an
the rest sort as expected. The table from which the PT is created, the name
are sorted Alpha. I've checked for hidden characters, the formating of th
cells, changed it from general to text and back again. Nothing seems t
work. Anybody got a clue? TI

Gre
 
It may not be practical for your data source, but you can add a space at
the end of the troublesome airport codes (e.g. SAT<space>) and they'll
sort correctly in the pivot table.

To change the names, select the column in the data source,
and choose Edit>Replace
In the Find what box, type: SAT
In the Replace with box, type: SAT and press the spacebar
Click the Replace All button
Confirm the replacement, and click Close
 
Back
Top