Share via


QueryTable.RobustConnect Property

Excel Developer Reference

Returns or sets how the PivotTable cache connects to its data source. Read/write XlRobustConnect.

Syntax

expression.RobustConnect

expression   A variable that represents a QueryTable object.

Remarks

XlRobustConnect can be one of these XlRobustConnect constants.
xlAlways . The cache always uses external source information (as defined by the SourceConnectionFile or SourceDataFile property) to reconnect.
xlAsRequired . The cache uses external source info to reconnect using the Connection property.
xlNever . The cache never uses source info to reconnect.

If you import data 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 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.

See Also