XlRobustConnect enumeration (Microsoft.Office.Interop.Excel)

XlRobustConnect enumeration

Office 2013 and later

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

No code example is currently available or this language may not be supported.

	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.