Cancels all background queries for the specified query table. Use the Refreshing property to determine whether a background query is currently in progress.
expression.CancelRefresh
expression Required. An expression that returns a QueryTable object.
Example
This example cancels a query table refresh operation.
With Worksheets(1).QueryTables(1)
If .Refreshing Then .CancelRefresh
End With