PivotCache.OLAP Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  Sub CheckPivotCache()

' Determine if PivotCache has OLAP connection.
If Application.ActiveWorkbook.PivotCaches.Item(1).<strong class="bterm">OLAP</strong> = 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