Export (0) Print
Expand All
Expand Minimize

XlRobustConnect Enumeration

Specifies how the PivotTable cache or a query table connects to its data source.

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.

Community Additions

ADD
Show:
© 2014 Microsoft