Share via


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