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

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?

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


[email protected] wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html