ok here's more detail:

1. I have an application from which I export data to .txt file
2. From excel I import the data
3. I auto refresh the imported data range everytime I want to update the
excel.

By doing # 3, there are new records which I want to get appended starting
from the last row or user defined row. But that doesn't happen and the
existing records are disturbed. i.e., new records (cells) overwrite/replace
the existing records.

"Debra Dalgleish" wrote:

Where do you want the new data to go? Where are the existing records?

Perhaps you can manually cut and paste at the end of the current data,
or create a macro to append the records. However, to get specific help,
you'll need to provide some details on what you're trying to do.

Nipun wrote:
How do I Insert new rows without disturbing existing records. I am using data
import and then populating the excel sheet. I have tried setting Data range
properties but that didn't help


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html