Keeping Column Widths the same in a pivot table when pages increase

[cailotto]

I've created a pivot table and because of the length of the characters
in the page, the column width keeps changing. How do I keep the column
width the same?

 

[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