i have file named "repo link," (XLS,, old format) which has links to workbook called "repo template" (XLSM, 2010).

essentially, the "repo link" will only update the values when I open it (the source, the repo template, file does NOT even have opened for the repo link file to update...this is not the case where the file won't update unless the source file is open at the same time).

this is causing an issue because i have another file, called "capital," which links to the "repo link" file. if the repo link file doesn't get updated, that means that the capital file won't get updated as well.

currently the workaround is in the "capital" file, i have a macro that opens the "repo link" file, save then close, then the capital numbers are updated based on the latest repo link files. again, this solves the issue because the links in the "repo link" file get updated once the file gets opened and saved.

(i know, i know...this is retarded...because it should ust be "capital" linked to "repo tempalte" instead of "capital" linked to "repo link" linked to "repo template.")

tl;dr, why does the repo link file only updated when I open it?