ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why is my row truncated in a pivot table? (https://www.excelbanter.com/excel-discussion-misc-queries/49851-why-my-row-truncated-pivot-table.html)

mcmunnd1

Why is my row truncated in a pivot table?
 
my source of the pivot table has a data field with 81 words, yet only 44
words show up in the results table. How can I get the entire 81 words in the
pivot table?

Debra Dalgleish

A pivot table cell is limited to 255 characters. There's no setting you
can change to increase this limit.

mcmunnd1 wrote:
my source of the pivot table has a data field with 81 words, yet only 44
words show up in the results table. How can I get the entire 81 words in the
pivot table?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 08:54 PM.

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