| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables - Text From Source Being Truncated
Hi, I have a source file that I am using in my pivot table. It is text
information. There are 118 (602 char) words in the source file for the field, but in the pivot, only 43 words (211 char) appear. How can I expand this to include all text/char? Thanks, Kathie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Tables - Text From Source Being Truncated
In Excel 2003 and earlier versions, there's a 255 character limit to
text cells in a pivot table, and you can't increase that limit. In Excel 2007 the limit is much higher, about 32K. Kathie wrote: Hi, I have a source file that I am using in my pivot table. It is text information. There are 118 (602 char) words in the source file for the field, but in the pivot, only 43 words (211 char) appear. How can I expand this to include all text/char? Thanks, Kathie -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Pivot tables using the same source data | Excel Discussion (Misc queries) | |||
| Identifying Source Data for Pivot Tables | Excel Discussion (Misc queries) | |||
| Source Data in Pivot Tables | Excel Worksheet Functions | |||
| Force pivot tables to use same source data | Excel Discussion (Misc queries) | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Linear Mode
