max text characters in pivottable cell

  • Thread starter Thread starter josparkes
  • Start date Start date
J

josparkes

I have made a pivottable out of a list which contains answers to
survey. The comments making up some answers are more than 25
characters long. I have discovered that these answers are truncate
when they appear in my pivottable.
Is there a way to get round this so that all of my text will appear
or is this the maximum amount of text allowable in a pivottable cel
and I am going to lose some information.
Hope someone can help
Thankyou:confused
 
The character limit in a pivot table cell is 255, and as far as I know,
this setting can't be changed manually or programmatically.
 
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

PivotTable and summing/not summing 1
Pivot Table Page Field value from cell in another worksheet 3
Exclude Network Path In PivotTable Based on Sharepoint 1
Sorting in PivotTable 5
Excel 2010 - possible to have a Pivot Table cell return more than 256 characters? 4
Docking Pivottable toolbar in Excel 2
erratic response while working on a table in excel linked to a tab 2
View Pivot Table Source data as a Data Table 6

Back
Top