New rows at the end of a worksheet don't sort with the worksheet

[John Bloor]

I imported a dBase file as an excel worksheet. Editing the worksheet seems
to work normally except when I try to add a new row at the bottom of the
existing data. When I sort the worksheet on any column, the new row stays at
the bottom. If I insert the new row among the existing rows, it sorts with
the rest of the data. I am using MS Office Excel 2003/SP2.