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.