共用方式為


PivotTable.ViewCalculatedMembers Property (Excel)

When set to True (default), calculated members for Online Analytical Processing (OLAP) PivotTables can be viewed. Read/write Boolean.

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.

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

請參閱

概念

PivotTable Object Members

PivotTable Object