Share via

XlRobustConnect Enumeration

  • Article

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.