Sorting - Excel 2007

[Chet Swanson]

I use Excel 2007 quite often for lists and other functions that require
sorting. When I set up specific sort orders in a spreadsheet those "orders"
do not stay with the spreadsheet when I save the file.

In previous versions of Excel when I set up a sort order for a spreadsheet
and saved the file when I came back to the file at some later time the sort
order was still there. With Excel 2007 I have to re-do the sort order every
time I open the file again.

Am I doing something wrong? Thanks for your thoughts.

Chet

 

[Roger Govier]

Hi Chet

No, you're not doing anything wrong.
That seems to be the behaviour in XL2007.
I can only suggest you switch on the macro recorder when you carry out your
sort, then invoke the macro each time.

 

[ilia]

I have not experienced this behavior. I often use the Table feature,
so that might be where the sort order is remembered. But each time I
go to the sort dialog box, it has all my levels in the order I
previously used, and data never gets "unsorted" after I close a
workbook.

 

[Roger Govier]

Hi

That's very interesting.
I just tried it again and it worked perfectly, just as you described.
Previously I had experienced the same behaviour as the OP described.

I had a hard disk crash recently, and had to re-install all of my software.
Whether that has made the difference, I don't know.