Excel Cell Data Limit

R

rwiegel

I am creating an ASP.NET page to dump data to an excel file. This
works fine, but when I open the excel file I get an error that says
'the cell data is too large'. I heard from somebody that excel cells
can hold up to 32,000 character, but can only display 1,024 characters
in the formula bar. What restrictions does this impose on the data
that cannot be displayed? If I do a keyword search, is that data
still going to get searched?

Thanks in advance,

Ryan
 
G

Guest

hil
from excel help. Type specifications.
32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar
i've never tried to pack 32,767 characters in a cell but if they will
display, i would assume you can search them. not real sure how it would
display the find.

Regards
FSt1
 
R

rwiegel

Even in the formula bar the entire text is not displayed. I know
there is no problem with the data dump itself because when I try to
type more characters in the formula bar I get an error saying that the
formula is too long. Any ideas?
 
G

Guest

hi.
not really. as i said, you're on ground where i have never been.
question. why are you dumping that much data into a single cell. seems to me
in that lay the problem. I don't think i could manage data that way. I would
seriously consider a better way of bringing it in.
the info i posted is from excel help xp2003. copy and paste.
sorry i could not be more help.
Regards
FSt1
 
D

Dave Peterson

I put
=rept("x",32765)&"y"
in A1:A5
and converted to values (edit|copy, edit|pastespecial|values)

And then I did edit|find to search for y's. It found those y's at the end of
those strings.

On the other hand, I've used Edit|Replace in long strings and gotten "Formula
too long" error messages returned--but never with edit|find.

But I'm not sure what a keyword search is for your application.

You may want to do some testing.
 
E

Earl Kiosterud

If the cell does actually contain a formula (a formula starts with the = character), not a
number or text, then the formula length limit applies. I couldn't find formula length limit
in the Limits and Specifications part of Help, but it was 1024 characters in Excel 2000.

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
P

Peter Grebenik

Find (in values) in Excel 2003 certainly finds text in a cell
containing a long text string.

I have written an Excel addin for dealing with cells containing long
text strings. It contains a simple cell viewer/editor to allow you to
read and edit the content of a cell.

You can download it from
http://wwwusers.brookes.ac.uk/p0054663/PDGExcelUtils.xla

Once it is installed just use the Escape key to start the cell text
edit form.

Peter Grebenik
 

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

Code character limit with Resize or Transpose or cell? 8
Data validation list limit 4
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
limit on the delimited list for Data Validation. 2
Slow chart problems with very large data sets 1
limit on cell contents 1
limit cell input 3
Problem with text in cell 2

Top