Share via


PivotCache.OLAP Property (Excel)

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

Syntax

expression .OLAP

expression A variable that represents a PivotCache object.

Example

This example determines whether or not 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 

See Also

Concepts

PivotCache Object

PivotCache Object Members