Each time you Refresh a Pivot Table you will most likely get annoyed at the fact that the column widths that you worked so hard to align – will return back to normal 🙁

Do not fear, Pivot Table Options is here!

All you need to do is Right Click in the Pivot Table and choose PivotTable Options and then under the Layout & Format tab you need to “uncheck” the box that says: Autofit column widths on update

Next time you update your data and Refresh your Pivot Table, the column width will never change 🙂

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Right click in the Pivot Table and select Pivot Table Options

 

STEP 2: Uncheck Autofit Column Widths on Update

 

STEP 3: Update your data

 

STEP 4: Refresh your pivot table

Our Pivot Table column widths do not change anymore!

Keep Column Width Upon Refresh

HELPFUL RESOURCE:

728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Errors When Grouping By Dates With Excel Pivot Tab... In our Group By Date post, we grouped our sales numbers by weeks.However there are times when we try to group by Dates and we get an error message!  That is frustrating!Instead of checking the dates one by one to find out where the error occurred, I will show you a cool w...
Group By Month With Excel Pivot Tables Before I was a Pivot Table guru, I had to get individual rows of daily sales and group them into a report showing the monthly sales during the year.Grouping these would take a ton of effort using Formulas:Extracting the month and year from each transactional date; Th...
Pivot Table Conditional Formatting Inserting a Pivot Table is very easy to do in Microsoft Excel: Inserting a Pivot TableAdding some Conditional Formats to the Pivot Table allows a user to highlight key data in a split second.See how easy it is to add some color to your analysis.DOWNLOAD WORKBOOK...
Connect Slicers to Multiple Excel Pivot Tables Pivot Table Slicers were first introduced in Excel 2010 for Windows and Excel 2016 for Mac.They are a visual filter in the form of an interactive button.  There are several cool things that you can do with Slicers, like customize them, filter them and connect them to mult...