ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot text fields (https://www.excelbanter.com/excel-discussion-misc-queries/78757-pivot-text-fields.html)

George

Pivot text fields
 
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


Peo Sjoblom

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


Regards,

Peo Sjoblom


"George" wrote in message
...
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





All times are GMT +1. The time now is 03:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com