Has anyone ever came across pivot tables no longer sorting? Last week they worked fine. I have "ascending" set under advanced - but for some reason my values are sorting in a very odd order - neither ascending or descending.
I decided to test a very basic pivot table.
For my test example, below are the words I typed in:
application
business name
criticality
name1
name2
name
vendor
vendor1
vendor2
name
$ name
But they appear sorted in the following "ascending" order:
name
vendor
$ name
name
application
business name
criticality
name1
name2
vendor1
vendor2
Any ideas what's going on? I'm using Excel 2003.
Bookmarks