This documentation is archived and is not being maintained.

PivotTable.InnerDetail Property (Excel)

Returns or sets the name of the field that will be shown as detail when the ShowDetail property is True for the innermost row or column field. Read/write String.

expression .InnerDetail

expression A variable that represents a PivotTable object.

This property isn’t available for OLAP data sources.

This example displays the name of the field that will be shown as detail when the ShowDetail property is True for the innermost row field or column field.

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable 
MsgBox pvtTable.InnerDetail
Show: