How do I check and/or change to overwrite the target cell? I've already created the query and I can't find where to edit the overwrite option (Excel 2002)
Select a cell in the external data range.
Choose Data>Import External Data> Data Range Properties
Change the setting for 'If the number of rows in the data range changes'
Click OK
