Pivot text fields

G

Guest

When I add a text field to the data area in a pivot table, the data displayed
is truncated to 255 chars,. The source data was created using MS Access 2002
and the text field (in Excel) contains more that 255 chars (Memo field in MS
Access).
How do I display the text field with more that 255 char in a pivot table?

George
 
P

Peo Sjoblom

There is AFAIK now way to bypass this, you can see the limits in help under
specifications


Regards,

Peo Sjoblom
 

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
Formula fields in Pivot Tables? 1
Summing Formula fields in Pivot Tables? 3
Formula fields in Pivot table reports? 2
Pivot table date grouping 2
Pivot table drill down sort 0
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Using text values in Pivot Tables 5

Top