How to show more than 255 characters in Pivot

Closed
gameover - Jan 29, 2009 at 01:42 AM
 kevski - Mar 24, 2009 at 05:32 AM
Hello,

I have a pivot table in which 1 column(nearly 1800 rows) have characters nearly about 2000. But the pivot table shows only 1st 255 characters, can you please help me to show all the characters in pivot table???

Thanks in Advance!!!

PS: I am using Excel 2003!!!
Related:

4 responses

vanniva Posts 11 Registration date Monday April 7, 2008 Status Member Last seen April 5, 2009 2
Jan 29, 2009 at 03:03 AM
Hello,

First of all make sure that you have well pivoted your excel sheet and that it is in the right direction. Hence, make sure that you have not any limitations on the filters. Else, it's normal that you will have only 255 characters, try to put it above average or customize it by inserting above 2000 characters
1
Hi,

Thanks for the answer! Can you please elobarate a little bit your answer! As far as manually putting the characters, I have tried it but in vain!! :(
1
vanniva Posts 11 Registration date Monday April 7, 2008 Status Member Last seen April 5, 2009 2
Jan 29, 2009 at 03:33 AM
Ok then tell me first what are the procedures that you went through to pivot the table and I will tell you what is wrong with it
1
did you ever get your answer? wanna share? ;-)
if you got your answer, or you worked it out, would you mail me - kevski_is@hotmail.com - this problem is killing me!
1
you can't. looks like it's hard-coded.
0