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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Kris" wrote:

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?