PivotCache.OLAP property (Excel)

Returns True if the PivotTable cache is connected to an Online Analytical Processing (OLAP) server. Read-only Boolean.

Syntax

expression.OLAP

expression A variable that represents a PivotCache object.

Example

This example determines whether the cache connection is to an OLAP server. The example assumes that a PivotTable exists on the active worksheet.

Sub CheckPivotCache() 
 
 ' Determine if PivotCache has OLAP connection. 
 If Application.ActiveWorkbook.PivotCaches.Item(1).OLAP = True Then 
 MsgBox "The PivotCache is connected to an OLAP server" 
 Else 
 MsgBox "The PivotCache is not connected to an OLAP server." 
 End If 
 
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.