Pivot table format

[eli]

Hi everyone,

I have a pivot table that i reformated the size of the
columns to make it nicer. when i add data, i go back to
my pivot table to refresh the data, and everything is
recalculated but the size of the columns is lost, it
comes back to the default size.

How can i have the column size stay as i put them when i
refresh the data ?

Thanks

 

[Debra Dalgleish]

You can turn off AutoFormat in the PivotTable, and the column width
adjustments should be retained:

1. Right-click on a cell in the PivotTable, and choose Table Options
2. Remove the check mark from AutoFormat Table, click OK