Lock Pivot Table Column Width

[Christine]

Hi,

Everytime I refresh my pivot table the column width
changes. Is there a way to set and lock the column widths
of the pivot table.

Thanks,
Christine

 

[Debra Dalgleish]

As answered in microsoft.public.excel.misc --

Turn off AutoFormat in the PivotTable, and the column width should be
retained:

Right-click on a cell in the PivotTable
Choose Table Options
Remove the check mark from AutoFormat Table
Click OK

 

[Debra Dalgleish]

You could leave the AutoFormat option turned on, and record a macro to
reset the column widths after the pivot table is refreshed.