Saving Sorts

[Ron]

I rarely use Excel, so this may be a very elementary
question, but...

On one of my worksheets, I cannot get a Sort to save --
that is, when I select sort, there is no previously used
sort as the default. The sort itself works fine (once I
manually go through setting it up). Also, on every other
worksheet, this works fine.

 

[Casey]

Ron,
Normally, the kind of "automatic" memory Excel and other offic
products exhibit in their interfaces are dependent on saving the fil
when we exit. So, if this is a file you open, take a look at, after yo
sort that is, but then close the file and decline to save the file whe
asked, you lose that cool "auto" stuff. Now, I'm not a programmer jus
a very frequent user of Excel and I too rely on the program rememberin
my last sort preferences and I can't recall having your problem. But
always save as I close the file. So that might be the problem.
Case

 

[CLR]

Hi Ron.............

I suggest you look into recording your own macro to do the sort for you if
you do the same one all the time...........just do Tools > Macro > Record
new macro.........and then follow the menu and perform the steps as normal
and then hit Tools > Macro > Stop recording.............then you have it.
Give it a try, and if you run into trouble, just come back here and someone
will help.

hth
Vaya con Dios,
Chuck, CABGx3