Pivot Table Sort Error

C

cory

I have a list of state abbreviations in a pivot table:
CAL KAN MON TEX

When I sort them A to Z in a pivot table, I get the following result:
MON CAL KAN TEX

What is happening?
 
T

Ted M H

Hi Cory,

Questions:
1. Do you have a custom list set up in your Excel installation?
2. Are you sorting using the PivotTable sort tools or are you sorting using
the quick sort buttons on the standard toolbar or the standard Sort dialog
box?
3. What version of Excel are you using?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table Data Column Sort Excel 2007 1
Typing Over Pivot Table Rows and Columns 1
Pivot Table- Column 2 sort 3
Pivot Table Help 1
Pivot Table sort -Excel 2007 4
Pivot Table Sort 1
Question on the occupied field of the pivot table in excel spreadsheet 0

Top