Excel 2007 sorting problem

[Rhonda]

In Excel 2007, every time I change ranges, and even sometimes when I move
away from a range and then come back to an old range, I have to re-enter the
sort parameters every time.

In Excel 2003, and for some versions before, if I sorted a selected range
(say A4:Q54) by Col A Asc, Col G Asc, and Col C Desc then Excel would remember
the sort parameters so that if I changed ranges to say A60:Q100 it would
keep those same parameters loaded and I could just simply sort my data
without having to re-enter the sort parameters all over again.

Please direct me to where I can get some help on this issue.