QueryTable.RobustConnect Property
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. |