PivotTable and column widths

[Peter Aitken]

Am I correct in believing that there is no way to change the column widths
in a PivotTable and have them preserved during updates?

 

[Debra Dalgleish]

Set the pivot table to preserve formatting:
On the pivot toolbar, choose PivotTable>Table Options
Add a check mark to 'Preserve formatting', click OK
Remove the check mark from AutoFormat Table
Click OK

 

[Peter Aitken]

Thanks!

Set the pivot table to preserve formatting:
On the pivot toolbar, choose PivotTable>Table Options
Add a check mark to 'Preserve formatting', click OK
Remove the check mark from AutoFormat Table
Click OK