Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Broken Links
Hello Everyone,
I have one file that has many Vlookup links to three other files. Whenever I close the source files I get the following errors; 1. #N/A 2. #REF Once the source files are reopen the values return. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Broken Links
=vlookup() doesn't have trouble with closed workbooks.
But other functions do. Maybe you used =indirect() in your formula? You may want to share your current formula to see if anyone has a workaround that'll help. wrote: Hello Everyone, I have one file that has many Vlookup links to three other files. Whenever I close the source files I get the following errors; 1. #N/A 2. #REF Once the source files are reopen the values return. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Broken Links | Excel Discussion (Misc queries) | |||
broken links | Excel Discussion (Misc queries) | |||
Broken Links.... | Excel Discussion (Misc queries) | |||
Broken Links | Excel Discussion (Misc queries) | |||
Links are broken and cannot fix | Excel Worksheet Functions |