Thanks!
"Debra Dalgleish" wrote in message
...
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
Peter Aitken wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html