How to Fix the Column Width in Pivot Table When Updating

By default the column width will change when you update the pivot table, please see below to stop autofit the column width:

Step 1: Right-click any cell in the Pivot Table;

Step 2: Click "PivotTable Options" from the list;

Step 3: Uncheck the box of "Autofit column widths on updates".

Leave a Reply