Home

Pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-850776%22%20slang%3D%22en-US%22%3EPivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-850776%22%20slang%3D%22en-US%22%3EHello.%20I%20have%20created%20a%20pivot%20table%20using%20data%20in%20another%20excel%20sheet.%20The%20original%20data%20sheet%20contains%20text%20cells%20with%20long%20text.%20In%20the%20pivot%20table%2C%20only%20part%20of%20the%20text%20is%20displayed%20in%20the%20each%20cell%2C%20the%20rest%20of%20the%20text%20can%20be%20seen%20when%20hoovering%20over%20it%20with%20a%20mouse.%20But%20it%20is%20not%20visible%20at%20the%20cell%20itself.%20Have%20you%20encountered%20this%20issue%3F%20Any%20idea%20how%20to%20solve%20it%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-850776%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-850943%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-850943%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F395081%22%20target%3D%22_blank%22%3E%40AndreaJu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDid%20you%20apply%20Wrap%20text%20to%20the%20column%20with%20text%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-851203%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-851203%22%20slang%3D%22en-US%22%3E%40Sergei%20-%20Wrap%20text%20on%20or%20off%2C%20does%20not%20make%20any%20difference.%20The%20cell%20still%20shows%20only%20part%20of%20the%20original%20text.%20It%20looks%20as%20if%20there%20is%20a%20setting%20that%20limits%20the%20number%20of%20characters%20in%20a%20cell....%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-851525%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-851525%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F395081%22%20target%3D%22_blank%22%3E%40AndreaJu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECell%20stores%20up%20to%2032767%20characters%2C%20but%20PivotTable%20truncates%20it%20to%20256%20characters%20which%20are%20shown%2C%20see%20for%20example%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcelribbon.tips.net%2FT011784_Text_Truncated_in_PivotTable.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcelribbon.tips.net%2FT011784_Text_Truncated_in_PivotTable.html%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EHowever%2C%20I%20checked%20on%20my%20Excel%20with%20simple%20test%2C%20it%20shows%20more%2C%20here%20is%20about%201000%20characters.%20Never%20had%20practical%20experience%20with%20so%20long%20texts%20in%20Pivot%20Table%20before.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20403px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131462iB4ABC3EA3B455DD0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-851581%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-851581%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E-%20you%20may%20be%20onto%20something%20here.%20My%20cells%20have%20up%20to%202%20000%20characters%20and%20only%20the%20initial%20couple%20hundred%20get%20shown.%20Is%20there%20any%20way%20to%20get%20past%20those%20256%20characters%20and%20increase%20it%20to%202000%3F%3C%2FLINGO-BODY%3E
AndreaJu
New Contributor
Hello. I have created a pivot table using data in another excel sheet. The original data sheet contains text cells with long text. In the pivot table, only part of the text is displayed in the each cell, the rest of the text can be seen when hoovering over it with a mouse. But it is not visible at the cell itself. Have you encountered this issue? Any idea how to solve it?
4 Replies

@AndreaJu 

Did you apply Wrap text to the column with text?

@Sergei - Wrap text on or off, does not make any difference. The cell still shows only part of the original text. It looks as if there is a setting that limits the number of characters in a cell....

@AndreaJu 

 

Cell stores up to 32767 characters, but PivotTable truncates it to 256 characters which are shown, see for example https://excelribbon.tips.net/T011784_Text_Truncated_in_PivotTable.html

However, I checked on my Excel with simple test, it shows more, here is about 1000 characters. Never had practical experience with so long texts in Pivot Table before. 

image.png

@Sergei Baklan - you may be onto something here. My cells have up to 2 000 characters and only the initial couple hundred get shown. Is there any way to get past those 256 characters and increase it to 2000?
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies