Pivot Table - Wrapping Text

In my Pivot Table, I have all the column headers formatted to "wrap text".
When I select new data to display in the pivot table, it removes the wrapping
on the column headers. I've deselected the AutoFormat Table option, but the
behavior continues.

Any way around this?

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.


Kirk P. wrote:
> In my Pivot Table, I have all the column headers formatted to "wrap text".
> When I select new data to display in the pivot table, it removes the wrapping
> on the column headers. I've deselected the AutoFormat Table option, but the
> behavior continues.
>
> Any way around this?


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

In addition to the above I had to take all filters off the pivot-table to get it to work. After I did that it was fine.

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 5th hit in Google when I searched for "pivot table erases word wrap format on refresh"