PivotCache.RobustConnect Property
Returns or sets 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
Property RobustConnect As XlRobustConnect
Get
Set
'Usage
Dim instance As PivotCache
Dim value As XlRobustConnect
value = instance.RobustConnect
instance.RobustConnect = value
XlRobustConnect RobustConnect { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlRobustConnect
Remarks
XlRobustConnect can be one of the following XlRobustConnect constants:
xlAlways The cache always uses external source information (as defined by the SourceConnectionFile or SourceDataFile property) to reconnect.
xlAsRequired The cache uses external source info to reconnect using the Connection property.
xlNever The cache never uses source info to reconnect.