Pivot tables and column widths

K

Krissy

Is there a way to permanently reset the column widths in a pivot tables? I
am able to change the column width, but it defaults back to a standard width
each time I refresh the pivot table. Can I set it up so that it will stay at
a width defined by me?

Thanks!
 
T

trip_to_tokyo

In EXCEL 2007 try this:-

1. Right click the Pivot Table / PivotTable Options . . . / Layout & Format
tab / remove the tick from:-

Autofit column widths on update

OK

If my comments have helped please hit Yes.

Thanks
 

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

Format column widths from one table to a separate table on same page 1
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
Dates In Excel 5
VBA - (re-) Set a Table Style 2
Column width of Pivot Table data goes back to default when data refreshed 5
Table Preferred width is changed when pasting 1
Column widths in Excel 2013 16

Top