The file retains the last sort order when you save it. IF you mean that
you want a programed sequence of sorts done resulting in different sort
orders for you to look at, then yes you will need a macro.

rolando wrote:

Excel 2007
I'm use some sheets which need to sorted in several different ways; is there
a way to save sorting data orders (beside making VBA macro for these) ?