PivotCell.MDX Property (Excel)

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

Version Information

Version Added: Excel 2010

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.

See Also

Concepts

PivotCell Object

PivotCell Object Members