Sorry, I have no ideas.
It would help to know which version of Excel you are using and how you
are causing the new row to be inserted.
Are there any macros in the file?

If you like, email the file to me at Bill underscore Manville at
Compuserve dot com, and tell me where / how to insert a row to see the
effect.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup