Syntax

expression.RefreshStyle

expression A variable that represents a QueryTable object.

Remarks

XlCellInsertionMode can be one of these XlCellInsertionMode constants.
xlInsertDeleteCells Partial rows are inserted or deleted to match the exact number of rows required for the new recordset.
xlOverwriteCells No new cells or rows are added to the worksheet. Data in surrounding cells is overwritten to accommodate any overflow.
xlInsertEntireRows Entire rows are inserted, if necessary, to accommodate any overflow. No cells or rows are deleted from the worksheet.

Example

This example adds a query table to Sheet1. The RefreshStyle property adds rows to the worksheet as needed, to hold the data results.

Visual Basic for Applications 
Dim qt As QueryTable Set qt = Sheets("sheet1").QueryTables _ .Add(Connection:="Finder;c:\myfile.dqy", _ Destination:=Range("sheet1!a1")) With qt .RefreshStyle = xlInsertEntireRows .Refresh End With
refresh Refresh style refreshstyle refreshstyle property

See also: