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