[SOLVED] pivot table - keep text wrapped on refresh?

[Cheryl]

How can I make sure that text stays wrapped when I refresh a table. I have a
description field about work completed.. and sometimes it exceeds the column
width.. I can choose to wrap text for the whole column.. but when I refresh..
it reverts back.. I have autoformat off and preserve formatting on for the
pivot table.

Thanks in advance for your assistance

[Debra Dalgleish]

You may have to enable selection (From the Pivot toolbar, choose
PivotTable>Select, and click on Enable Selection)

Before formatting cells, instead of selecting the entire column, use the
selection feature to select the items in the description field. For
example, move the pointer to the top of a column in the pivot table
(just above the column's heading cell). When the black arrow appears
(like the one that appears when the pointer is over a column button),
click to select the column in the pivot table. Then apply the formatting.

If that doesn't work, you could record a macro as you refresh and
reformat the pivot table. Then, run the macro when you want to update.


Cheryl wrote:
> How can I make sure that text stays wrapped when I refresh a table. I have a
> description field about work completed.. and sometimes it exceeds the column
> width.. I can choose to wrap text for the whole column.. but when I refresh..
> it reverts back.. I have autoformat off and preserve formatting on for the
> pivot table.
>
> Thanks in advance for your assistance


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[tjejojyj]

That solution didn't work for me.

The tips that did work are:
1. take off any filters you have in the pivot table. (<<< THIS WAS KEY)
2. hover the point over the header until it forms a black down arrow to select the entire column (or over the row header left edge, to select a row)
3. tick "preserve formatting on update" in the p-t option (although this is seems to be not meaningful)

Tim

PS: Credit where credit is due, my solution comes from http://datapigtechnologies.com/blog/...matting-stick/
PPS: I know this is an old thread but it is still the 4th hits in Google when I searched for "pivot table erases word wrap format on refresh"

[FDibbins]

Thanks for the feedback