I have a pivot table. I have (and want) one of the column's cells set to word wrap. The content in the cells is word wrapped, but on refresh, the ROW height does not autofit for the refreshed content.

Here is what I have noticed:

In the "Pivot Table Options" there is an option under "Layout & Formatting" > "preserve cell formatting on update".  When I have "preserve formatting" selected, all the formatting is retained, including the word wrap.  However, on data refresh the row height does not auto fit the new word wrapped content.

Alternatively, if I unselect "preserve formatting", all the pivot table formatting is lost, including the word wrap.  However, the rows auto fit back the unwrapped row height.

It is important to note that there is an option in the Pivot Table Options under "Layout & Formatting" to "Autofit Column Widths on Update".  I have this uncheck, and it works.  It seems like there should be an "Autofit ROW Heights on Update" option.  If there was, I would select this.

Anybody know how to make this work?

Thanks!

Hi,

Based on my test, there is no such option like "Autofit ROW Heights on Update" yet. Thus, we may try the workaround in this thread, I have copied here:

==

I was having this problem as well.  It seems to really give me problems when I try to set the height on a pivot where I have rotated the headings.  My fix is to create a cell somwehere in my sheet on the same row as the pivot table headings and fill it with text until the auto-height was the size I wanted my pivot headings.  Then I set it to white on white.  Now when I refresh my pivot it takes that "hidden" cell into account and the height stays.

http://answers.microsoft.com/en-us/office/forum/office_2007-excel/row-height-being-reset-on-refresh/027b1e43-4868-4ac7-8e18-22097647585d?page=1

==

Hope it's helpful.

Regards,