Edit

Share via

PivotTable.InnerDetail property (Excel)

  • Article

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.

Syntax

expression.InnerDetail

expression A variable that represents a PivotTable object.

Remarks

This property isn't available for OLAP data sources.

Example

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

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.