Removing Characters in Pivot Table

[v234]

I have an excel pivot table that comes from a power query that is fed from an access database. There is a column which holds large comments (200 to 2,000 characters). The pivot table looks fine but if I click into one of the large comment cells (into the actual text portion) and then click out of the cell, it deletes a portion of the text (I'm assuming down to 255 characters). If I do not click inside, it will keep the text how it originally was. If I click inside the text and then click out, I can't get that text back, even after refreshing the pivot. The query still holds the correct information but the pivot table will no longer pull it in correctly. Trying to figure out how I can keep these comments in their original form without having to be concerned about accidentally clicking in a cell (since this workbook is used all day long). Also, trying to think of a solution that will require no ongoing maintenance or concern. Thanks in advance!

 

[GraH]

This might interest you: How to Skirt the 255 Character Limit Within Excel Pivot Tables
Or try loading the data in datamodel (PowerPivot) and create your pivot from there. Text limit is 32766 positions (64bit, I think)