ResetTimer Method

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