hi
the max is IMHO 255 characters if the other file is closed

--
Regards
Frank Kabel
Frankfurt, Germany

"CIDERIE" schrieb im Newsbeitrag
...
I have specifications in one file and results in another.
When the results file looks up data in the specifications file only
half the
text in a long filed is displayed when the source is inactive. If I
load the
source file at the same time then all the data is displayed. is this
a
"feature" of excel 2003 it never happened in excel 97?