PivotCell.MDX property (Excel)

  • Article

Returns a tuple that provides the full MDX coordinates of the specified value cell in a PivotTable with an OLAP data source. Read-only.

Syntax

expression.MDX

expression A variable that represents a PivotCell object.

Return value

String

Remarks

The dimensions returned in the tuple by the MDX property include row and column coordinates as well as report filter coordinates.

For cells outside the values area of the PivotTable, and outside a PivotTable, accessing this property will generate a run-time error.

For PivotTables with multi-item selection in a report filter field, accessing this property will also generate a run-time error.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.