Truncation on Excel 2003

E

Elsa

Hi!

I tried to get an answer from someone about the handling
of "merged cells" in Excel 2003 when the worksheets are
created on a previous version of Excel. When the "DO NOT
UPDATE" choice is made, most of the contents of the merged
cell are truncated -- with only the first couple of lines
kept. It works fine on Excel XP. No one answered my
question. Does anyone know if Microsoft has a fix to this
bug? The 2003 version seems to have lots of problems. This
is the second one so far. The first one was in its
handling of files in Novell servers.

Please answer me. We really are frustrated. Thanks.
 
S

SLOTS4ever

Dave Peterson said:
If you have a link to a workbook, you can return lots of characters. But if you
close that workbook and recalculate, then the max number of characters that can
be returned is 255.
Click to expand...

Dave -
Is this documented? I have a user that is having this problem and I am
looking for the document that states that 255 bytes will be returned until
the source is opened.
 
D

Dave Peterson

You could search the MS Knowledge base and find lots of hits dealing with 255
character limits:
http://support.microsoft.com/search/default.aspx?Query=excel+255+characters

Here's one going from Excel to Access:
The data in a linked Excel spreadsheet column is truncated to 255 characters
in an Access database
http://support.microsoft.com/default.aspx?scid=kb;en-us;839785

And for XL98 (macintosh):
XL98: Linked Formula May Return a Maximum of 255 Characters
http://support.microsoft.com/default.aspx?scid=kb;en-us;181369

I didn't see any for windows versions, but I didn't look very long.
 
Top