Specify how new data is added to an external data range
- Click a cell in the external data range, and then click Data Range Properties
on the External Data
toolbar. - In the External Data Range Properties dialog box, under If the number of rows in the data range changes upon refresh, choose an option to insert new cells or entire rows, or to replace existing data when you refresh.