Is there a limit on characters allowed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a limit on characters allowed in a cell? when using a pivot report?
Can that limit be changed?
 
Is there a limit on characters allowed in a cell? when using a pivot report?
Can that limit be changed?
Click to expand...

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
 
when i enter notes about something only half are showing up in the pivot
report. We use 2003.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cell character limit 8
Cell Formats - Limit # of characters 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Limiting the number of characters in a cell 5
# of Characters/cell 2
256 character limit in pivot tables 1
Is there a limit number of characters for cells in pivot Tables? 2
limit number of characters in cell 4

Back
Top