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