Excel 2007 Pivot Table Sorting

G

Guest

I had 2 columns in the row data area of my pivot table. The columns
contained names as Last name and First name. The Pivot table was sorting a
name May to the top. I think Excel 2007 was interpreting the data and
sorting it as a month. I had to combine the last name, first name MI
together so it would sort properly.

Would you consider this a Bug?
 
D

Debra Dalgleish

You can turn that feature off:

Right-click the pivot table, and click PivotTable Options
On the Totals & Filters tab, remove the check mark from 'Use Custom
Lists When Sorting'
Click OK
 

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 in Excel 2007 & 2000 (backward compatibility problem) 3
Pivot table not sorting 2
Pivot Table Data Column Sort Excel 2007 1
Pivot Table sorting 1
Pivot table drill down data 2
How do I stop a Pivot Table from Sorting my data (Excel 2007) 1
Pivot table sorting 2
Sort choices in filter in pivot table 1

Top