Can't see all the text in a cell when using file links

[Mark]

I have never seen this one before. I have a spreadsheet, lets call this A,
that is linked to numerous other spreadsheets on my lan. When I call up
spreadsheet A, regardless of whether I update my links or not, the text in
the cell containing the link reference is truncated. I am not exceeding any
character length constraints here either. I know this because when I open up
the linked file B I can see the whole thing. Any ides? We are using Excel
2003. TIA

Mark

 

[Peo Sjoblom]

How many characters are we talking about? How much gets truncated?

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Dave Peterson]

If the sending file is open in the same instance of excel, you'll see all the
characters.

If the sending file is not open in that same instance of excel, you'll see 256
characters (well, after the first recalculation).

 

[Mark]

Thats correct. If the linked file is not open I only see about 256 chars,
but when the linked file is open I see all the text. Is this a bug in Excel?
Why can't I see the whole thing whether the linked file is open or closed?
Thanks

 

[Dave Peterson]

I think it's a design choice--not a bug.

I don't know away around it.