Pivot table format

  • Thread starter Thread starter eli
  • Start date Start date
E

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