Share via


QueryTable.RefreshPeriod Property

Excel Developer Reference

Returns or sets the number of minutes between refreshes. Read/write Long.

Syntax

expression.RefreshPeriod

expression   A variable that represents a QueryTable object.

Remarks

Setting the period to 0 (zero) disables automatic timed refreshes and is equivalent to setting this property to Null.

The value of the RefreshPeriod property can be an integer from 0 through 32767.

If you import data using the user interface, data from a Web query or a text query is imported as a QueryTable object, while all other external data is imported as a ListObject object.

If you import data using the object model, data from a Web query or a text query must be imported as a QueryTable, while all other external data can be imported as either a ListObject or a QueryTable.

You can use the QueryTable property of the ListObject to access the RefreshPeriod property.

See Also