freeze column width in a pivot table

[Guest]

I am preparing an important document and I need to be able to "freeze the
column width in a pivot table, so that when I enter more information the
column won't change and show: ####### instead of an amount.

thank you

 

[Excelenator]

All you need to do is select the pivot table column (hover over th
field name until the black arrow shows up) and then left click t
select the entire column of data. Once this is done you can set you
column width for that column and when you refresh your data the colum
width won't change

 

[Debra Dalgleish]

Right-click a cell in the pivot table, and choose Table Options
Ensure that Preserve Formatting is turned on, and AutoFormat is turned off.
Click OK