ResetTimer Method
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