A pivot table cell is limited to 255 characters. There's no setting you
can change to increase this limit.

mcmunnd1 wrote:
my source of the pivot table has a data field with 81 words, yet only 44
words show up in the results table. How can I get the entire 81 words in the
pivot table?


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