Site icon Professor Excel

How to Avoid Changing the Column Width When Refreshing PivotTable

In a previous Excel Tip we have learned how to create a simple Excel Pivot Table. Now we will go on from there and learn how to eliminate one of the major pains of Pivot Tables: It changes the size of the columns after each update of the values.

Steps for fixing the column width when updating Pivot Tables

When you change your data, you have to refresh the Pivot Table. Therefore, right-click on any value and click on “Refresh”. Now, the column width adapts to the new data – even if you carefully changed the columns before. To avoid that, do the following steps (the numbers are corresponding to the picture above):

  1. Right click on any value within your Pivot Table.
  2. Click on “PivotTable Options”.
  3. Remove the tick at “Autofit column widths on update”.

That’s it. Now the column width stays the same on each update.

Do you want to know one more very helpful tip about PivotTables? Read here how to disable the “GETPIVOTDATA” when you refer to a PivotTable.

Exit mobile version