Pivot Table - Text column

  • Thread starter Thread starter wk choy
  • Start date Start date
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
 
The character limit in a pivot table cell is 255, and as far as I know,
there's no way to change this setting.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Pivot Table date format 1
EXCEL07 how to use text in a PivotTable value field 1
Pivot text fields 1
Issue with pivot table 1
Using text values in Pivot Tables 5
Referencing a pivot tables Grand Totals Column 1
256 character limit in pivot tables 1

Back
Top