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

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

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