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