Saving Sort Criteria in 2007

[Guest]

Before in Office 2003 if I had a worksheet that I always used the same sort
setup and I saved the worksheet it would always bring that sort criteria up
when I hit sort.

Now in 2007 it doesn't seem to matter what I do even if I sort several times
in the same session I keep having to add levels to the sort which can be time
consuming. Am I missing something?

Thanks

 

[Guest]

Hi

I think below extract explained this situation:

"Sort criteria are saved with the workbook so that you can reapply the sort
each time that you open the workbook for an Excel table, but not for a range
of cells. If you want to save sort criteria so that you can periodically
reapply a sort when you open a workbook, then it's a good idea to use a
table. This is especially important for multicolumn sorts or for sorts that
take a long time to create."

for more detail, go here:

http://office.microsoft.com/en-us/excel/HP100739471033.aspx?pid=CH100648451033

hope this help.

regards

Leung