Link Updates

Good Morning,
I am having issues with the links function of excel to were it displays the following:
"Excell cannot update one or more links in this workbook. To update the links, open alll teh link source files (Edit menu, Links command). To be sure all calculations are updated, press F9"

The spreadsheet that I created as a template give me this message every time that I try to update. This spreadsheet is obtaining information from another spreadsheet that also contains links as well. Is there anythign that I can do to turn this off and update without opening the source files?

Attached is the workbook that gives me the alert stated in my first post. The formulas are basic addition of values found in different cells on 6 different spreadsheets. The files were created in 2 different formats of excel if that would matter (2003 and 2007).