Pivot tables
 

Hello,
I have a data set and have created pivot tables using this data set. In my
data set I have a column for comments so that I may write text. I have
created a pivot table and incorported my "comments" column in the pivot table
as a column. However in my pivot table the cells in the "comments" column
seem to be cutting off half of the text that I have written in the original
cell in the "column" on my data set. In my data set I can of course see the
entire text that I wrote in each cell but in the pivot table it gets cut off.
Can anyone help me fix this?

Thanks,
Chris

Pivot tables
 

In Excel 2003 and earlier versions, there's a 255 character limit to
text cells in a pivot table.

kanstrup wrote:
Hello,
I have a data set and have created pivot tables using this data set. In my
data set I have a column for comments so that I may write text. I have
created a pivot table and incorported my "comments" column in the pivot table
as a column. However in my pivot table the cells in the "comments" column
seem to be cutting off half of the text that I have written in the original
cell in the "column" on my data set. In my data set I can of course see the
entire text that I wrote in each cell but in the pivot table it gets cut off.
Can anyone help me fix this?

Thanks,
Chris


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

Pivot tables
 

Thanks a ton Debra.

"Debra Dalgleish" wrote:

In Excel 2003 and earlier versions, there's a 255 character limit to
text cells in a pivot table.

kanstrup wrote:
Hello,
I have a data set and have created pivot tables using this data set. In my
data set I have a column for comments so that I may write text. I have
created a pivot table and incorported my "comments" column in the pivot table
as a column. However in my pivot table the cells in the "comments" column
seem to be cutting off half of the text that I have written in the original
cell in the "column" on my data set. In my data set I can of course see the
entire text that I wrote in each cell but in the pivot table it gets cut off.
Can anyone help me fix this?

Thanks,
Chris


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