Why can't save SORTS?

[George]

An using MS Office 2002 Excel. Have various worksheets that I always sort a
certain way... for instance, a list sorted by Column B, then Column A,
then Column C...(with no header row). Problem is... everytime I go to sort,
I have to RE-ENTER the B, A, C sort criteria. Is there a way to save it for
a specific worksheet file?

Have had some suggestions to write macros, but this takes time, and it seems
like surely there is a way to retain the last sort entered. Lotus 123 saves
your last sort criteria with the spreadsheet. Alternatively, does MS Office
*2003* Excel correct this?

Would appreciate ideas or if this is way it's supposed to work and why.

Thanks

 

[BrianB]

FWIW XL97 saves sort criteria with the file.

Regards
BrianB
===========================