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 

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.