Pivot tables and column widths

[Krissy]

Is there a way to permanently reset the column widths in a pivot tables? I
am able to change the column width, but it defaults back to a standard width
each time I refresh the pivot table. Can I set it up so that it will stay at
a width defined by me?

Thanks!

 

[trip_to_tokyo]

In EXCEL 2007 try this:-

1. Right click the Pivot Table / PivotTable Options . . . / Layout & Format
tab / remove the tick from:-

Autofit column widths on update

OK

If my comments have helped please hit Yes.

Thanks