OLEDBConnection.CancelRefresh (Excel)

Cancels all refresh operations in progress for the specified OLE DB connection.

Use the Refreshing property to determine whether a refresh operation is currently in progress.

ActiveWorkbook.Connections(1).OLEDBConnection.CancelRefresh