Look ups only working if file open

[Joanna410]

Hi

Since the latest update in excel, all links / lookups into other files do not work unless the other file is open. Never before did you have to have the source file open. 

Any ideas if this can be fixed ?

Thanks