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

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


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=568491

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


Martha Navarro wrote:
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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html