Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |