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
Highlighted
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
Highlighted

@AndreaJu 

Did you apply Wrap text to the column with text?

Highlighted
@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....
Highlighted

@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

Highlighted
@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
Counting Days
Tim Hunter in SQL Server on
2 Replies
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
Problem sorting Pivot Table according to date
MikkoS in Excel on
1 Replies