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