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