I found a working solution he
http://www.mrexcel.com/archive/Pivot/14589.html
" Format Text in a Pivot Table
Posted by Mark W. on April 14, 2001 1:53 PM
Malc, setting the "Preserve formatting" PivotTable
Format option isn't prescriptive by itself. You
also must set Enable Selection by right-clicking
on your PivotTable and choosing the "Select
Enable Selection" command. Once you've done this
you must right-click on the PivotTable once again
and choose the "Select Label" command. Now you
can select the desired field label, and apply the
Alignment Wrap text format. I should also mention
that prior to performing these steps you may want
to temporarily set all PAGE fields to "(All)".
If you don't your applied formatting will only be
established for the existing settings. For more
on this see the Excel Help topic for "Format a
PivotTable". Hope this helps!"
Quote:
Originally Posted by Lorie
it was checked....
--
thank you, Lorie
"Debra Dalgleish" wrote:
Right-click on a cell in the pivot table and choose Table Options
Make sure that the Preserve Formatting box is checked.
Lorie wrote:
everytime i do a sort for data, such as on one client or another, the column
with case notes looses the formating.... and word wrap is lost.... is there
anything i can do to make it not loose the word wraping each time?
Thank you again
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
|