External links (Closed workbook)

I am trying to keep an external link active without having to open the source file. I would like to have the source file update once I open the destination file without the destination file opening. ...