| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link to external s/sheet changes to #Value!
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 | |||
| Link to external s/sheet changes to #Value! | Excel Worksheet Functions | |||
| How do I get rid of an external link which I can't find? | Excel Discussion (Misc queries) | |||
| 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) | |||
Linear Mode
