[LarryH]

Problem linking values from one wookbook / sheet to anouther. Almost all
cells work fine but some do not, they do however if I copy/paste the lookup
value into a "search all sheets" and double click the cell in the source
sheet that contains the lookup value.

Example: Look up cell for destination file on sheet1 = 1234
Look up cell from source file on sheet2 = 1234

Both are formated as "text" but the vlookup data is not transfered until I
double click on the cell containing 1234 in the source file sheet2 then it
works fine until I update the file again.

[Bill Manville]

Sorry, Larry, but I am not quite following you.
Please could you clarify:
- which version of Excel
- whether source and destination workbooks are open, or only
destination
- what is the calculation mode
- what is the formula containing the link
- what value is it showing
- what value is in the cell you expect to be referenced by the link.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

[ShaneDevenshire]

Hi,

This often occurs when there is a data type mismatch between the item you
are looking up and the first column of the lookup table. If they are numbers
they must both be numbers, if the are number displayed as text they must both
be text.

Find on of the offending items and try the =ISTEXT(A1) function or the
ISNUMBER(A1) function on both the number you are looking up and that value in
the first column of the lookup table.

--
Thanks,
Shane Devenshire


"LarryH" wrote:

Problem linking values from one wookbook / sheet to anouther. Almost all
cells work fine but some do not, they do however if I copy/paste the lookup
value into a "search all sheets" and double click the cell in the source
sheet that contains the lookup value.

Example: Look up cell for destination file on sheet1 = 1234
Look up cell from source file on sheet2 = 1234

Both are formated as "text" but the vlookup data is not transfered until I
double click on the cell containing 1234 in the source file sheet2 then it
works fine until I update the file again.