Pivot text fields

G

George

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

Power Pivot. Yikes. 0
Pivot Table Counting Text Data 0
Truncating SQL Server "Text" field 5
Excel does not accept text format! 0
Slicers and Calculated Items in Pivot Table 2
255 truncation 1
Pivot table drill down sort 0
Adding a comment in a footnote area 1

Top