Trying to lock column width in a pivot table

I am trying to lock the column with in a pivot table, so when the row information is changed the column width stays the same.  Not sure if this is even possible.
Answer
Answer

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.

Thanks.

 

 

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.

 
 

Question Info


Last updated August 26, 2019 Views 36,444 Applies to: