Is there a 255 character limit in pivot table cells?

G

Guest

Is there a 255 character limit in pivot table cells? I have text in some of
the fields and these are being truncated at 255 characters. CAn this limit
be increased by formatting the pivot table to Text, or General, or Custom?
 
D

Dave Peterson

Like in a row field in your pivottable?

Yep, there's a limit.

No, I don't think you'll find a way to change this limit.
 

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
TOO MANY CHARACTERS!!!! - PIVOT TABLE 5
Pivot table cell limit 2
Circumventing the 255 character header/footer limit 8
vlookup character limitations 1
Limitations with Pivot Tables 4
Limit access in a pivot table 2
character limit in hyperlink function 0

Top