External Links not updating for closed files

[Antonw]

Dear All,

I have got one excel (Destination file) file in which I have used SUMIFS function linked with another excel file (Source file). When I open the destination file and update links, instead of showing the amounts, it shows #VALUES . It will properly update only if I open the source file. Opening the source file always is difficult and I want to get this done without opening the source.

Can someone please help me sort out this issue?

Thanks in advance

AW