Pivot Table - Text column

W

wk choy

I have data on an excel worksheet which includes several
columns of long text data. When I create a pivot table,
the text is truncated.

How do I stop the truncation of text data in pivot table?

Thanks
 
D

Debra Dalgleish

The character limit in a pivot table cell is 255, and as far as I know,
there's no way to change this setting.
 
Top