ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot tables do not display all the text in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/126853-pivot-tables-do-not-display-all-text-cell.html)

mattvmills

Pivot tables do not display all the text in a cell
 
When a cell has a significant amount of text, only the first 200 or so
characters are displayed in a pivot table. Is there anyway to increase this?

Debra Dalgleish

Pivot tables do not display all the text in a cell
 
A pivot table cell will show a maximum of 255 characters, and you can't
increase that limit.

mattvmills wrote:
When a cell has a significant amount of text, only the first 200 or so
characters are displayed in a pivot table. Is there anyway to increase this?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


bob in calif

Pivot tables do not display all the text in a cell
 
Have they addressed this yet to increase the size?

"Debra Dalgleish" wrote:

A pivot table cell will show a maximum of 255 characters, and you can't
increase that limit.

mattvmills wrote:
When a cell has a significant amount of text, only the first 200 or so
characters are displayed in a pivot table. Is there anyway to increase this?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



Debra Dalgleish

Pivot tables do not display all the text in a cell
 
Yes, in Excel 2007 it's increased to over 32,000 characters

bob in calif wrote:
Have they addressed this yet to increase the size?

"Debra Dalgleish" wrote:


A pivot table cell will show a maximum of 255 characters, and you can't
increase that limit.

mattvmills wrote:

When a cell has a significant amount of text, only the first 200 or so
characters are displayed in a pivot table. Is there anyway to increase this?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com



All times are GMT +1. The time now is 06:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com