Excel.QueryTable.ResetTimer.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
QueryTable.ResetTimer method (Excel)	vbaxl10.chm518121	vbaxl10.chm518121	Excel.QueryTable.ResetTimer	9e8c9d26-fe11-90f7-6073-c8ff5be3042d	05/03/2019	medium

QueryTable.ResetTimer method (Excel)

Resets the refresh timer for the specified query table or PivotTable report to the last interval that you set by 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

[!includeSupport and feedback]