DetailWidth Property

See Also                  Applies To

PivotField object: Returns or sets the width of the specified field (in pixels) when it is displayed in the detail grid. Read/write Long.

PivotView object: Returns or sets the width of the detail grid (in pixels). Read/write Long.

Use the PivotView object’s DetailRowHeight property to set the detail grid height.

If the PivotView object’s DetailAutoFit property is set to True, the detail width is automatically reset when the PivotTable list is refreshed. If you set the DetailWidth property programmatically, the DetailAutoFit property is automatically set to False.