Right click in the Pivot Table / click on PivotTable Options . . . / PivotTable Options window should launch in the Layout & Format tab.
The penultimate field is called:-
Autofit column widths on update
Remove the tick (check) from this field and hit OK.
If my comments have helped please Vote As Helpful.
106 people were helped by this reply
Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this response?
Thanks for your feedback.