To ensure that the external data does not replace existing data, make sure that the worksheet has no data below or to the right of the cell you click.
To return the data to the location you selected, click Existing worksheet, and then click OK.
To return the data to a new worksheet, click New worksheet, and then click OK. Microsoft Excel adds a new worksheet to your workbook and automatically puts the external data range in the upper-left corner of the new worksheet.