Freeze Column Width?

  • Thread starter Thread starter Emma
  • Start date Start date
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.
 
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.
 
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
 
Have you tried deselecting the Autoformat option in the table settings? It
workd for me!!
 
Sorry, didn't understand that suggestion the first time -
I did as you suggest and, yes, that fixes it. Thanks very
much!

Emma
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot tables and column widths 1
freeze width of a column used by pivot table 4
Pivot Table: Resulting Column Widths on Drill Down 0
Pivot table column widths 1
freeze column width in a pivot table 2
Pivot table column widths 1
convert text to columns 2
Column Width Behavior 1

Back
Top