QueryTable.ResetTimer Method (Excel)

Resets the refresh timer for the specified query table or PivotTable report to the last interval you set using the RefreshPeriod property.

Syntax

expression. ResetTimer

expression A variable that represents a QueryTable object.

Example

This example resets the refresh timer for the first query table on the active worksheet.

ActiveSheet.QueryTables(1).ResetTimer

See also

QueryTable Object