Edit

Share via

QueryTable.CancelRefresh method (Excel)

  • Article

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.