software

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?

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:
gt; I am using Excel 2002.
gt; Whenever I change the order of the row items in the layout of a pivot table,
gt; the column widths are inappropriate for the data that they contain,
gt; and I must readjust them.
gt; Is there not a way to ensure that this happens automatically?--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlUnfortunately, there was already a check mark in the quot;Autoformat Tablequot; box.
For some reason it doesn't seem to cover column-widths

quot;Debra Dalgleishquot; wrote:

gt; You can try the AutoFormat option --
gt;
gt; Right-click on a cell in the pivot table
gt; Choose Table Options
gt; Add a check mark to AutoFormat table
gt; Click OK
gt;
gt; Pastel Hughes wrote:
gt; gt; I am using Excel 2002.
gt; gt; Whenever I change the order of the row items in the layout of a pivot table,
gt; gt; the column widths are inappropriate for the data that they contain,
gt; gt; and I must readjust them.
gt; gt; Is there not a way to ensure that this happens automatically?
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;