QueryTable.CancelRefresh Method

Syntax

expression.CancelRefresh

expression A variable that represents a QueryTable object.

Example

This example cancels a query table refresh operation.

Visual Basic for Applications
`With Worksheets(1).QueryTables(1) If .Refreshing Then .CancelRefresh End With`

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