I've possibly seen some of your breakage with Sharepoint, while supporting an integration product between Excel and some enterprise systems.
Does the problem persist if you ensure the other source files are open before opening "report file"?
If opening the files in the right order solves it, then it may be possible to script this in Excel or in an Excel add-in (optionally, signed).