QueryTable.ResetTimer Method

Excel Developer Reference

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.

Visual Basic for Applications
  ActiveSheet.QueryTables(1).ResetTimer

See Also