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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.