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,
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.