VLOOKUP
 

I have noticed that my "slave" file, containing a VLOOKUP formula, is
unable to pull across the entire contents of a cell from the "Master"
file when the "Master" file is unopened; it works OK when both "Master"
and "Slave" are open. The "Slave" file is "shared" and I really do not
want others to have the "Master" file open on their PCs. Is there any
way of overcoming what appears to be a maximum limit on the amount of
characters that can be transferred from an unopened file to an opened
file? By trial and error it would seem that the maximum number of
characters that can be transferred is about 250-260. Regards Mal.

VLOOKUP
 

I doubt it. The first 255 characters of a string are stored with the cell
information - but the remaining characters are stored in a string table - so
I would suspect the linking code does not possess the ability to
parse/locate the additional information out of/in the string table.

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
I have noticed that my "slave" file, containing a VLOOKUP formula, is
unable to pull across the entire contents of a cell from the "Master"
file when the "Master" file is unopened; it works OK when both "Master"
and "Slave" are open. The "Slave" file is "shared" and I really do not
want others to have the "Master" file open on their PCs. Is there any
way of overcoming what appears to be a maximum limit on the amount of
characters that can be transferred from an unopened file to an opened
file? By trial and error it would seem that the maximum number of
characters that can be transferred is about 250-260. Regards Mal.