XlRobustConnect XlRobustConnect XlRobustConnect Enum

Definition

Specifies how the PivotTable cache connects to its data source.

public enum class XlRobustConnect
public enum XlRobustConnect
Public Enum XlRobustConnect
Inheritance
XlRobustConnectXlRobustConnectXlRobustConnect

Fields

xlAlways xlAlways xlAlways 1

The cache always uses external source information (as defined by the SourceConnectionFile or SourceDataFile property) to reconnect.

xlAsRequired xlAsRequired xlAsRequired 0

The cache uses external source info to reconnect using the Connection property.

xlNever xlNever xlNever 2

The cache never uses source info to reconnect.

Applies to