To update the links automatically as you open any workbook: 1) Open Microsoft Excel workbook.
2) Click the 'Microsoft Office' button on the top left. (The 'Excel Options' dialog box appears.) 4) From the left pane, click 'Advanced'.
Then click OK to close this dialog, when you open this workbook next time, the links are automatically updated, and additionally, no message appears.
I have a 2013 Excel document with external links to other documents.
(The 'Advanced' screen appears.) 5) From the 'General' group, clear the 'Ask to update automatic links' check box. Knowledge-Paks Online and Knowledge-Paks On Site Copyright (c) 2007 by Right Answers, Inc.