MaxWidth Property

See Also                  Applies To

Returns or sets the maximum width that the specified PivotTable list or 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. For PivotTable lists, the value is in pixels. For spreadsheets, the value is in pixels or a percentage of the container window width (expressed as a string such as "50%"). The default value is 32,000 pixels for PivotTable lists, and 80% for spreadsheets. Read/write Long for PivotTable; read/write Variant for Spreadsheet.