G
Guest
Is there a limit on characters allowed in a cell? when using a pivot report?
Can that limit be changed?
Can that limit be changed?
D
david.ritchie.au
Hi Lorie
32,000 characters in a cell with Excel up to version 2003. Not sure
about pivot table cells, but would expect them to be the same.
Excel 2007 holds more per cell, but I could be wrong
Cheers
David
G
Guest
when i enter notes about something only half are showing up in the pivot
report. We use 2003.
report. We use 2003.
P
Peo Sjoblom
You are asking 2 questions. Dave answered one part of it, 32000 characters
can be entered in a cell BUT only 1024 will display, now that can be
overcome by using a lot of alt + enters but how much it can be overcome I
don't know.. If by any chance I would need to put a large piece of text in
Excel I use a text box
Data and page fields in a pivot table is 256 characters
row and column fields limited by available memory
if you use help and type "specifications" you can see for yourself
can be entered in a cell BUT only 1024 will display, now that can be
overcome by using a lot of alt + enters but how much it can be overcome I
don't know.. If by any chance I would need to put a large piece of text in
Excel I use a text box
Data and page fields in a pivot table is 256 characters
row and column fields limited by available memory
if you use help and type "specifications" you can see for yourself