Why is my Excel spreadsheet's sorting not being remembered?
 

I have a workbook with multiple spreadsheets. As I change/add data, I resort
these sheets. One of my spreadsheets defaults the sorting criteria I used in
the previous sort and remembers that I use headers. The other spreadsheet
used to do the same, but now does not 'remember/default' any of my previous
sort information or the fact that the spreadsheet contains headers. Is there
a setting that I can change so that this sorting information is remembered?
Thanks much,
Lisa