Dear Experts,

I've looked through almost all the posts and could not find an answer to this.

I have a spreadsheet (Excel 2003) with 10 columns that have been sorted
everyday for the last few months. The users delete info from a particular
row between 5 & 21 (information only, NOT the row), then highlight rows 5-21,
click DataSort, have been choosing the header column name from the first
'Sort by' option (header is in row 4), click OK and it sorts without having
to click any other buttons. Today, the 'Sort by' options in the drop down
list are showing the info in row 5 not the header names. Can anyone tell me
what's happened? Why would they now, after all this time, have to choose the
'No header row' button?

I'm just a little stumped. What am I missing and is there a way to default
the 'No header row' button?

Thanks for any and all your assistance!!!
ramona