This can be painful when you always want, or don't want, links updated.
Lot's More: Excel Macros Update Links in Excel When you have formula links in an Excel Workbook (destination) to another Excel Workbook (source) you will be asked if you wish to update links in the Workbook (destination) each time you open it.
Automatic update of the embedded and linked objects is extremely powerful feature of Microsoft Word, but it could be boring for a large document.
Locking a link prevents the object from being updated by the original application file, such as an Excel spreadsheet file.
It's not unusual for us to run a model that references back to 20 other Excel files.