QueryTable.RobustConnect (Excel)

Returns or sets how the query table connects to its data source. Possible return values are xlAlways - The PivotTable cache or query table always uses external source information (as defined by the SourceConnectionFile or SourceDataFile property) to reconnect, xlAsRequired - The PivotTable cache or query table uses external source information to reconnect by using the Connection property, xlNever - The PivotTable cache or query table never uses source information to reconnect.

If you import data by using the user interface, data from a web query or a text query is imported as a QueryTable object, while all other external data is imported as a ListObject object. If you import data by using the object model, data from a web query or a text query must be imported as a QueryTable, while all other external data can be imported as either a ListObject or a QueryTable. You can use the QueryTable property of the ListObject to access the RobustConnect property.

ActiveCell.QueryTable.RobustConnect = xlAlways