ResetTimer Method
From Microsoft Excel Visual Basic
Resets the refresh timer for the specified query table or PivotTable report to the last interval you set using the RefreshPeriod property.
expression.ResetTimer
expression An expression that returns a PivotCache or QueryTable object.
Example
This example resets the refresh timer for the first query table on the active worksheet.
ActiveSheet.QueryTables(1).ResetTimer