preserving column width format in excel pivot tables

C

Colin Foster

Hi all,

Is there a way to preserve the column formatting on a sheet containing a
pivot table?

At the moment I have a pivot table where the column data has wide text, but
a maximum of double digit (i.e <99) values. So, to avoid the PT being too
wide to fit onto a screen, I've set the headings cell alignment to vertical,
which works fine. Then I set the column width to 4, again, fine for the
first time. However, whenever I refresh or change one of the parameters, the
column width increases - even where this is not required (i.e. because a
wider column has been inserted). Is there a way of preserving the column
widths?

Regards
Colin Foster
 

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
Format column widths from one table to a separate table on same page 1
Dealing with a Pivot Table (when I don't want to) 0
Dates In Excel 5
Pivot tables and column widths 1
Table Preferred width is changed when pasting 1
Column width of Pivot Table data goes back to default when data refreshed 5
Referencing a pivot tables Grand Totals Column 1

Top