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


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