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