XlRobustConnect Enumeration

Specifies how the PivotTable cache connects to its data source.

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

Syntax

'Declaration
Public Enumeration XlRobustConnect
'Usage
Dim instance As XlRobustConnect
public enum XlRobustConnect

Members

Member name Description
xlAsRequired The cache uses external source info to reconnect using the Connection property.
xlAlways The cache always uses external source information (as defined by the SourceConnectionFile or SourceDataFile property) to reconnect.
xlNever The cache never uses source info to reconnect.

See Also

Reference

Microsoft.Office.Interop.Excel Namespace