How to show more than 255 characters in Pivot [Closed]

Report
-
 kevski -
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!!!
Posts
11
Registration date
Monday April 7, 2008
Status
Member
Last seen
April 5, 2009
2
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 5766 users have said thank you to us this month

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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 5766 users have said thank you to us this month

Posts
11
Registration date
Monday April 7, 2008
Status
Member
Last seen
April 5, 2009
2
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 5766 users have said thank you to us this month

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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 5766 users have said thank you to us this month

you can't. looks like it's hard-coded.