#Ref

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.