OLEDBConnection.AlwaysUseConnectionFile (Excel)

True if the connection file is always used to establish a connection to the data source.

When this property is True the connection file will always be used to establish the connection to the data source. If the connection embedded within the workbook is different from the external connection file, the embedded connection will be ignored and the external connection file will be the only version considered.

ActiveWorkbook.Connections(1).OLEDBConnection.AlwaysUseConnectionFile = True