Dec 05 2019
I am using Vlookup and Hlookup with files residing on a local area network. The main file refers to a separate file. Whenever I open the separate file it returns #REF errors in the main file. How can I prevent this error? It is very annoying.