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 Added: Excel 2010

expression .MDX

expression A variable that represents a PivotCell object.

Return Value


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.