DetailMaxHeight Element (Microsoft Excel)

Specifies the maximum height (in pixels) that the detail grid can attain when the size of the cell is automatically adjusted to fit the data.

Contained In

PivotView

Remarks

This element contains an integer. A scroll bar is displayed if the height of the detail grid would exceed the maximum height. The default height is 250 pixels. If the NoDetailAutoFit element is specified, the DetailMaxHeight and DetailMaxWidth elements are not specified.