A co-worker has a pivot table where one of the source columns refers to cells
that could contain more than 255 characters. The pivot table works, but
truncates the text at 255 characters.

Is there any way the pivot could show the whole text?