You can try the AutoFormat option --

Right-click on a cell in the pivot table
Choose Table Options
Add a check mark to AutoFormat table
Click OK

Pastel Hughes wrote:
I am using Excel 2002.
Whenever I change the order of the row items in the layout of a pivot table,
the column widths are inappropriate for the data that they contain,
and I must readjust them.
Is there not a way to ensure that this happens automatically?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html