Excel 2007 : Sort Error - Excel 07 - Pivot Tables - Help Needed!

[Steve_D]

Hi.

In Excel 2003 you could sort the differences column in a pivot table but it wont let me do it in Excel 2007 no matter what I try. I have a sales column and then a sales differences column which compares sales across tow years. When I try to sort the differences column it sorts the actual sales column.

The strange thing is that if I send the file to someone with excel 2003 it works fine, so its not the way Excel 2007 creates the pivots but looks to be Excel 2007 itself.

If anyone knows a work around or a way to get it to do this it would be much appreciated as its very annoying! The attached example is only very simple so its easy to see which has the greatest difference etc but if you were to have 500 customers it gets very difficult to use.

I have attached an example spreadsheet with the issue I am having as its hard to explain without an example.

[DonkeyOte]

If you right click on Customer -> Sort -> More Sort Options -> More Options -> uncheck "AutoSort" and click OK.

You should then find you can sort the Sales Diff column by right clicking on a value in said field -> Sort -> Largest to Smallest etc...

[Steve_D]

Thanks.

Worked perfectly!

That's gonna be a lifesaver - thought there would be a way but couldn't find it anywhere!