Search : in
By :

How to show more than 255 characters in Pivot

Last answer on Mar 24, 2009 9:32:54 am GMT gameover, on Jan 29, 2009 6:42:46 am GMT 
 Report this message to moderators

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!!!

Best answers for « How to show more than 255 characters in Pivot » in :
Photoshop – Show more than 10 recent files Show Photoshop – Show more than 10 recent files Issue Solution Issue Photoshop saves the last 30 files you have opened and used in its Recent Files list (File > Open recent) but will only display the last 10 of them! If you usually work on...
ASCII Code Show Data coding Morse code was the first code used for long-distance communication. Samuel F.B. Morse invented it in 1844. This code is made up of dots and dashes (a sort of binary code). It was used to carry out communication much faster than could...
[Sed] Delete one or more lines from a file Show [Sed] Delete one or more lines from a file Removing one (or several) line (s) of a file Syntax: sed '{[/]||[/]}d' sed '{[/][,][/]d' /.../=delimiters n = line number...
Show what you are listening to on MSN/WLM ShowShow what you are listening to on MSN/WLM Windows Media Player The Winamp Player The VLC Media Player The Foobar 2000 player When we are connected to instant messaging Windows Live Messenger, it is possible to display and use...
Laptop keyboard and Spanish characters ShowLaptop keyboard and Spanish characters It is very difficult to obtain Spanish characters (punctuation and accents) on the laptop keyboard. On a conventional pc keyboard (105 keys), it is much easier than on a laptop. In...
Making Pipe under Mac ShowPipe under Mac To enter the pipe character (|) under Mac OS, just type the key combination keyboard follows: Alt + Shift + L
Special characters ShowSpecial character codings HTML standards require all code to be written in 7-bit ASCII, which means that accented characters are not allowed. Despite this, current browsers recognise accented characters; you can enter accented characters directly...
Characteristics of programming languages ShowThere are many programming languages, each corresponding to specific needs (formula calculus, character string processing, real-time, etc.) with each having specific characteristics and functionalities. Therefore, the choice of programming language...
HTML forms ShowForms Interactive forms let web page authors give their pages interactive elements, such as for receiving messages from their readers, much like the reply cards found in some magazines. The reader enters information by filling in fields or clicking...
Ask your question Reply

1

vanniva, on Jan 29, 2009 8:03:06 am GMT

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

   
Reply to vanniva

2

gameover, on Jan 29, 2009 8:17:53 am GMT

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!! :(

   
Reply to gameover

3

vanniva, on Jan 29, 2009 8:33:32 am GMT

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

   
Reply to vanniva

4

kevski, on Feb 16, 2009 9:18:10 am GMT

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!

   
Reply to kevski

5

 kevski, on Mar 24, 2009 9:32:54 am GMT

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

   
Reply to kevski
Ask your question Reply
They need your help