Pivot Table column widths

[Guest]

Hello,

I am wondering if there is a way to lock in the current column widths of my
pivot tables so they won't change widths with new data. If not, I assume I
need to have code to change back to old column widths every time my tables
are refreshed? Thanks much,

Aaron

 

[Kristen]

Aaron,

Right click on your pivot table. Choose Table Options from the menu and
check the box called Preserve Formatting. This will stop the table from
changing the column widths when you refresh your data.

Kristen

 

[Debra Dalgleish]

Right-click on a cell in the pivot table, and choose Table Options
Remove the check mark from AutoFormat table, and click OK