Pivot table refresh - any way to keep it from re-sizing the width of columns??
I always have to resize the columns after refreshing.
I have some instances where i have to refresh after changing input and i have 2 grids below the pivot and any time i refresh it messes up the column widths so i have to keep resizing. It is annoying. Add a way to lock the column width so this wont happen every time i refresh.
This is already supported. After you initially create the PivotTable, you can do the following:
1. right click on the PivotTable and choose PivotTable Options…
2. On the Layout & Format tab, make sure that “Autofit column widths on update” is unchecked.
In the future, The best place to ask this question is the Excel area of answers.microsoft.com – specifically the Windows Excel Desktop area ( http://answers.microsoft.com/en-us/office/forum/office_2016-excel-os_device_win10desk?sort=lastreplydate&dir=desc&tab=threads&status=all&mod=&modAge=&advFil=&postedAfter=&postedBefore=&threadType=all&tm=1456878400400&auth=1 )
We’ve got folks over there who can help with questions like this, and we’re trying to keep the UserVoice site for new product ideas.
Hope that helps,
3 commentsComments are closed
Would it be possible that the tick is removed as the default? It would make so much easier.
@gmoProXL - for setting it as the default, you'll want to go vote for this item: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10535790-allow-users-to-set-choose-defaults-via-settings
Ok, but.. every time you create a new pivot table that box is checked. How can i have that unchecked permanently?? I never want it checked. Do you know how to do that? I dont just want to do it every time i create a pivot and have to uncheck that each time.