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
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
Problems using Pivot tables in Excel 16.25 on Mac
jeromepineau in Excel on
0 Replies