Pivot tables and column widths

  • Thread starter Thread starter Krissy
  • Start date Start date
K

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!
 
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
 
Back
Top