XlRobustConnect Enumeration
Specifies how the PivotTable cache or a query table connects to its data source.
Version Information
Version Added: Excel 2007
Name |
Value |
Description |
|---|---|---|
xlAlways |
1 |
The PivotTable cache or query table always uses external source information (as defined by the SourceConnectionFile or SourceDataFile property) to reconnect. |
xlAsRequired |
0 |
The PivotTable cache or query table uses external source information to reconnect, using the Connection property. |
xlNever |
2 |
The PivotTable cache or query table never uses source information to reconnect. |