I use pivot tables alot - and I am working with a pivot table where I've set
the column width to 9. When I pivot new information in, the column width
automatically adjusts to fit, then I have to go and reset the columns back to
9.

Is there anyway to override this "adust to fit" behavior and just let the
pivot table fit as much text as it can into the column width I specify?

Kirk,
Unselect the 'Autoformat Table' option in the Options section of the Pivot
Table.
HTH,
Gary Brown


"Kirk P." wrote:

I use pivot tables alot - and I am working with a pivot table where I've set
the column width to 9. When I pivot new information in, the column width
automatically adjusts to fit, then I have to go and reset the columns back to
9.

Is there anyway to override this "adust to fit" behavior and just let the
pivot table fit as much text as it can into the column width I specify?