Column Width - Pivot Table

T

Tom Nichol

I am using Excel 2000. When I drag a field name from the Pivot Table toolbar to the "row" area of the Pivot Table, the resulting column width is often inadequate to display the contents. Of course, I am not prevented from widening the column after the fact; however, it should ideally provide a "best fit" width automatically.
Is there something I am missing here?
 
D

Debra Dalgleish

You can turn on the AutoFormat option, and the columns widths should adjust to fit:

Select a cell in the PivotTable
From the PivotTable toolbar, choose PivotTable>Table Options
Add a check mark to 'AutoFormat Table'
Click OK
 
T

Tom Nichol

Debra,

I checked the Table Options and autoformat IS checked, but the colums in the
"row" area still do not resize. Could it possibly have any relation to the
fact that this pivot table is using an OLAP file as its source?

Thanks, and have a great weekend
 
Top