Sort not saved across saves/reopens

[Kris]

Okay, I have been using Excel 2007 for about 6 months or so and have run into
a really really annoying situation that will cause me to go back to Excel
2003 and most likely Office 2003, for complete compatibility reason.

I have a big spreadsheet that was created in Excel 2003. It has about 15-20
tabs and some tabs have sheets that I sort some of the columns by date or
name or whatever column I want to sort by that day. In Excel 2003 this is
remembered across sessions and in Excel 2007 it is not. I do not use any
special symbols or anything that would cause problems.

If I save my sort in Excel 2007 it is gone when I reopen it the next time.
The strange thing is that if I open the file in Excel 2003, which I have to
use sometimes at work, or other places, the sorts are there. So, this tells
me that it is an Excel 2007 issue.

Any idea what is going on?

 

[Shane Devenshire]

Hi Kris,

Works fine in my 2007 files. On each sheet it remember the last sort I did.
But only the last sort on any one sheet.

 

[Kris]

I have tried all types of things. The fact the file sorts fine, still, in
Excel 2003, tells me there is something wrong with Excel 2007 and this has
been across multiple Office 2007 machines and installs.

I have saved the file as an Excel 2007 xlsx file and it is fine. Again this
tells me that it is an Excel 2007 issue, not a file issue. I cannot save the
file as a 2007 version due to the fact too many people that need to edit it
and update the file only can use Excel 2003.