Excel.QueryTable.CancelRefresh.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
QueryTable.CancelRefresh method (Excel)	vbaxl10.chm518082	vbaxl10.chm518082	Excel.QueryTable.CancelRefresh	be9491bd-9b42-4b88-ddb9-554cf431e779	05/03/2019	medium

QueryTable.CancelRefresh method (Excel)

Cancels all background queries for the specified query table. Use the Refreshing property to determine whether a background query is currently in progress.

Syntax

expression.CancelRefresh

expression A variable that represents a QueryTable object.

Example

This example cancels a query table refresh operation.

With Worksheets(1).QueryTables(1) 
 If .Refreshing Then .CancelRefresh 
End With 

[!includeSupport and feedback]