CancelRefresh Method [Excel 2003 VBA Language Reference]
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
Applies to | QueryTable Object