External links (Closed workbook)

New Contributor

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. Will I have to write a macro to accomplish this or is there a setting that already exists to accomplish this? 

2 Replies
keep an external link active without having to open the source file

It is impossible because it is the behavior of Excel I guess。

Thank you for your response I will find a way to automate it. @peiyezhu