Excel Cell Data Limit

  • Thread starter Thread starter rwiegel
  • Start date Start date
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
 
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
 
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?
 
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
 
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.
 
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...
 
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
 
Back
Top