Syntax

expression.ViewCalculatedMembers

expression A variable that represents a PivotTable object.

Example

This example determines if calculated members can be viewed on the PivotTable and notifies the user. It assumes that a PivotTable exists on the active worksheet.

Visual Basic for Applications 
Sub CheckViewCalculatedMembers() Dim pvtTable As PivotTable Set pvtTable = ActiveSheet.PivotTables(1) ' Determine if calculated members can be viewed. If pvtTable.ViewCalculatedMembers = True Then MsgBox "Calculated members can be viewed." Else MsgBox "Calculated members cannot be viewed." End If End Sub
View view calculated members viewcalculated viewcalculatedmembers viewcalculatedmembers property

See also: