Linked files, error value unless manual close and open source file

[Kamolga]

Hi,

I am having a bit of an issue for my client: we have 2 excel files on the server. File 2 looks for values in file 1. When I open file 2, I always have error value, even if file one is opened. What I need to do is to close file 1 and reopen it to have the values to show up. What I don't get is that if I open file 1 through a macro, I keep the error value, so I still need to close the file and reopen it manually.

Thanks in advance for any guidance