Freeze Column Width?

E

Emma

Hi. I have a pivot table that combines data from many
workbooks. One column contains varying lengths of text,
so automatically resizes to much wider than desired each
time the pivot table is recalculated. All source
workbooks have this column sized at 50 with text
wrapping. Is there any way to freeze the column width in
the pivot table so that it doesn't resize? Thanks.
 
A

Andy B

Hi

If you right-click on the table, you can use the Table Settings option to
change the format. One which may be of use is the AutoFormat option.
 
E

Emma

Hi Andy,

Yes, I can resize the column to the desired width, but it
expands every time the data refreshes. I don't see any
way to permanently "freeze" the column to a certain
width. If you're aware of such an option, could you
please specify where to find it?

Thanks, Emma
 
A

Andy B

Have you tried deselecting the Autoformat option in the table settings? It
workd for me!!
 
E

Emma

Sorry, didn't understand that suggestion the first time -
I did as you suggest and, yes, that fixes it. Thanks very
much!

Emma
 
A

Andy B

Thanks for the thanks!

--
Andy.


Emma said:
Sorry, didn't understand that suggestion the first time -
I did as you suggest and, yes, that fixes it. Thanks very
much!

Emma
Click to expand...
 
Top