MaxWidth Property

Microsoft Office Web Components Object Model

Show All

MaxWidth Property

       

MaxWidth property as it applies to the PivotTable object.

Returns or sets the maximum width in pixels that the specified PivotTable list can attain when the value of the AutoFit property is True. A horizontal scroll bar is displayed if there is more data available that cannot be displayed within the maximum width. The default value is 32,000 pixels. Read/write Long.

expression.MaxWidth

expression   Required. An expression that returns a PivotTable object.

MaxWidth property as it applies to the Spreadsheet object.

Returns or sets the maximum width that the specified spreadsheet can attain when the value of the AutoFit property is True. A horizontal scroll bar is displayed if there is more data available that cannot be displayed within the maximum width. The value is in pixels or a percentage of the container window width (expressed as a string such as "50%"). The default value is 80%. Read/write Variant.

expression.MaxWidth

expression   Required. An expression that returns a Spreadsheet object.