PivotTable and column widths
 

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

--
Peter Aitken

Remove the crap from my email address before using.

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

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