Dec 05 2019 06:32 AM
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.