Imported Data Not Replacing Existing Data - Excel 2007
 

Hello,

In Excel 2007 we are trying to import an External Excel file into an
existing workbook, however, when the data is brought over it simply shifts
the old data to the right and places the new one to the left of the old data.
We have tried to specify the entire worksheet range and it still pushes the
old data to the right and the new one to the left.

In Excel 2003 you were able to check replace existing data. Is this option
still available in Excel 2007? Is there a way I can get the imported data to
replace the old one?

Thanks,