When you open a workbook that contains links to cells in other workbooks, you may receive the following message:
You can click either Update or Don’t Update. By default, Excel displays this message.
To suppress the message and to automatically update the links, follow these steps:
- In Excel, select File > Options > Advanced.
- Under General, click to clear the Ask to update automatic links check box.