Automatic update and no message
To suppress the message and to automatically update the links when you open a workbook in Excel, follow these steps:
Select File > Options > Advanced.
Under General, click to clear the Ask to update automatic links check box.
