Excel.PivotCache.RobustConnect.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotCache.RobustConnect property (Excel)	vbaxl10.chm227105	vbaxl10.chm227105	Excel.PivotCache.RobustConnect	354d0124-e178-342b-9565-fa74e9dae5d5	05/03/2019	medium

PivotCache.RobustConnect property (Excel)

Returns or sets how the PivotTable cache connects to its data source. Read/write XlRobustConnect.

Syntax

expression.RobustConnect

expression A variable that represents a PivotCache object.

Example

The following example determines the setting for the cache connection and notifies the user. The example assumes that a PivotTable exists on the active worksheet.

Sub CheckRobustConnect() 
 
 Dim pvtCache As PivotCache 
 
 Set pvtCache = Application.ActiveWorkbook.PivotCaches.Item(1) 
 
 ' Determine the connection robustness and notify user. 
 Select Case pvtCache.RobustConnect 
 Case xlAlways 
 MsgBox "The PivotTable cache is always connected to its source." 
 Case xlAsRequired 
 MsgBox "The PivotTable cache is connected to its source as required." 
 Case xlNever 
 MsgBox "The PivotTable cache is never connected to its source." 
 End Select 
 
End Sub

[!includeSupport and feedback]