Tips & Tricks 76 – Whenever I Refresh a Pivot, its Column Width Changes

You can stop Pivot from doing this behaviour. Take following steps –

1. Right Click on Pivot Table > PivotTable Options
2. Uncheck Autofit column widths on update.