PivotCache.OLAP property (Excel)

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



expression A variable that represents a PivotCache object.


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" 
 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.