WorkbookConnection.Refresh method (Excel)

Refreshes a workbook connection.

Syntax

expression.Refresh

expression A variable that represents a WorkbookConnection object.

Remarks

If the DisplayAlerts property is False, dialog boxes are not displayed, and the Refresh method fails with the Insufficient Connection Information exception.

A refresh failure for one connection will not have any impact on refresh operations for the other connections.

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.