Column width after Pivot Table changes

S

Steve

Hi,

In Excel 2002 (and all previous versions :|) whenever you move fields around
in Pivot Table view if you happen to have one field containing long text
strings the column widens out to fit its contents. This is not fun because I
have to manually reset the column width so I can see all the columns. Why
does the Pivot Table do this and is there a way to keep column widths fixed?

Thank you, Steve.
 

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

Setting column width in a table with a macro is not working 0
Dealing with a Pivot Table (when I don't want to) 0
Format column widths from one table to a separate table on same page 1
Table Preferred width is changed when pasting 1
Pivot table report invalid 0
Pivot table column width 2
Pivot Table Counting Text Issue 0
VBA - (re-) Set a Table Style 2

Top