In 2007 I have a sorting procedure. After I save and close the file and re-open it I get the following message

"Excel found undreadable content in ... Do you wish to recover contents ..."
I reply Yes. Then I get:

Removed Records: Sorting from /xl/worksheets/sheet2.xml part
If I then immediately save/close the file and re-open it without first running the sort macro, then everything is fine. There is no warning message. After I sort and do a save/close open the message returns - so clearly there's something in the sorting procedure that causes this.

No records are lost from the sorted range despite what the message might imply.

I don't know whether this is a factor since it seems un-related. But after I open the file and accept the warning message and before running the sort macro, if I then immediately click the 'Save' icon I'm presented with the File Save As dialog box rather than the file just being resaved. It appear that Excel is thinking this is a new file.

Any ideas??

Usual TIA