Pivot tables and column widths
In EXCEL 2007 try this:-
1. Right click the Pivot Table / PivotTable Options . . . / Layout & Format
tab / remove the tick from:-
Autofit column widths on update
OK
If my comments have helped please hit Yes.
Thanks
"Krissy" wrote:
Is there a way to permanently reset the column widths in a pivot tables? I
am able to change the column width, but it defaults back to a standard width
each time I refresh the pivot table. Can I set it up so that it will stay at
a width defined by me?
Thanks!
|