Pivot Sort Bug (2007/SP1)

Topic

New Reply

Anyone aware of an issue with Sorting data within pivot tables for Excel 2007? If so – is there a work-aound or some other solution? My solution so far has been to create the pivot in 2007; open the file on a machine with 2003 and re-sort correctly. But I may not always have access to the 2003 machine. Not sure how to add an image within a post so have attached a tiny sample. Sample is a listing of location IDs and their names concatenated together that should “sort like numbers” (as they do perfectly well in 2003).

Thanks,
Bill

Reply | Quote

Replies

I think I discovered the issue – and it has nothing to do with an Excel 2007 bug.

I have a custom list that contains a complete listing of the location IDs concatenated with the location names. Some of the location names are slightly different on the data source I am using for the pivot table. My guess is Excel attempts to maintain the integrity of the order in a customized list OVER any alpha-numeric sorting – and did the best it could with the mix of data in the pivot. And the reason it the sort worked “correctly” on the Excel 2003 machine – is because that machine did not have the custom list added.

I had to delete the custom list from my Excel 2007, but I did get the sort to work.

Reply | Quote

Thanks for posting the cause (and solution), it may well help someone else.

Reply | Quote