Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jun 2001
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Sort Bug (2007/SP1)

    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
    Attached Images Attached Images

  2. #2
    Star Lounger
    Join Date
    Jun 2001
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Sort Bug (2007/SP1)

    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.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot Sort Bug (2007/SP1)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •