Pivot table limitation

[Normand]

Hi, a pivot tale does not import more than 256 characters in a cell, why and is there a way to extend this limit?

Thanks

 

[Luke M]

256 character limit is a product of being one of the limits of XL. There's no way to "override" it in a PivotTable. Recommendation from this thread was to either shorten your import data to be less than 256, or switch to Access.
http://www.mrexcel.com/forum/excel-questions/119563-character-limit-pivot-tables.html

If I may, why do you need over 256 characters?

 

[Normand]

I use excel to follow some issues on project. Data to populate the excel file comes from an application were user can commnets on their issues in a cell and there is no limit on the number of characters in this field... The report from this application is exported to an excel file format and it includes all the comments from the users even those that exceed 256 characters. Using a pivot table to extract some specific information from that table, I see the limit of 256 characters, and it is not efficient. To compensate on that, I have added a column following the pivot table last column and use a vlookup formula to find the complete information I need and it brings the entire content of the cell... but it would be nice to have it deirectly from the Pivot Table

Regards

Normand