This documentation is archived and is not being maintained.

XlRobustConnect Enumeration 

Specifies how the PivotTable cache connects to its data source.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim xlRobustConnect1 As XlRobustConnect = XlRobustConnect.xlAlways

public enum XlRobustConnect
public enum XlRobustConnect
public enum XlRobustConnect

Member nameDescription
xlAlwaysThe cache always uses external source information (as defined by the SourceConnectionFile or SourceDataFile property) to reconnect.
xlAsRequiredThe cache uses external source info to reconnect using the Connection property.
xlNeverThe cache never uses source info to reconnect.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms