Class PivotValueCell (Excel VBA)

Provides a way to expose values of cells in the case that actual cells (Range objects) are not available.


To use a PivotValueCell class variable it first needs to be instantiated, for example

Dim pvc as PivotValueCell
Set pvc = ActiveCell.PivotTable.PivotValueCell()

PivotValueCell class variables can be set using the PivotTable.PivotValueCell procedure.


Returns the PivotCell object that specifies the location of the PivotValueCell.

Dim pvtlcelPivotCell As PivotCell
Set pvtlcelPivotCell = ActiveCell.PivotTable.PivotValueCell.PivotCell


Returns a collection of OLAP Action name objects that represent OLAP-defined actions that can be executed.

A server action is an optional feature that an OLAP cube administrator can define on a server that uses a cube member or measure as a parameter into a query to obtain details in the cube, or to start another application.

Dim actsServerActions As Actions
Set actsServerActions = ActiveCell.PivotTable.PivotValueCell.ServerActions


Puts the individual rows of an OLAP data source that contribute to an aggregate onto their own Excel worksheet.



Returns the value at the location. The value is the value after ShowAs and other calculations have been applied. Variant can be Empty, Number, Date, String, or Error value.

This property works independently of whether the PivotTable is on a worksheet or not.

Dim varValue As Variant
varValue = ActiveCell.PivotTable.PivotValueCell.Value