| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link to external s/sheet changes to #Value!
hi dave f..
i do not use vlookup, yet i believe the other generic "lookup()" function can do the job for such, without #value! error even when the sorce book is closed...editlinksupdate is possile and integral... thanks for the info... "Dave F" wrote: VLOOKUP does not work when it references data in a closed workbook. Dave -- Brevity is the soul of wit. "will" wrote: Hi, I have a vlookup link to an external spreadsheet. This works fine whilst the external spreadsheet is open, but if it is closed and I update links in the original spreadsheet, the formula result changes to #value! Why is this and can I stop it? Thanks, Will |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get rid of an external link which I can't find? | Excel Discussion (Misc queries) | |||
| Link to external link | Excel Worksheet Functions | |||
| How do I use a cell value as the filename in an external link? | Excel Discussion (Misc queries) | |||
| How do I use a cell value as the filename in an external link? | Excel Worksheet Functions | |||
| Save External Link Values | Excel Discussion (Misc queries) | |||
Hybrid Mode
