Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link to external s/sheet changes to #Value!
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 | |||
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 Worksheet Functions | |||
Save External Link Values | Excel Discussion (Misc queries) |