Excel Update Pop-up: This Workbook Contains Links To One Or More External Sources That Could Be Unsafe

News Knowledge Base
1

How can one avoid Excel link update popup?

Issue Description : When Robot tries to open Excel file, it shows a pop-up : "This workbook contains links to one or more external sources that could be unsafe". How can this pop-up be avoided ?

Pop-up Screenshot :

Resolution : This message is a Security Warning that Automatic update of links has been disabled.

To suppress the message and to automatically update the links when you open a workbook, follow these steps:

  1. Click Microsoft Office File, and then click Options.
  2. Click Advanced.
  3. Under General, click to clear the Ask to update automatic links check box. Refer Control Startup Message About Updating Linked Workbooks in Excel .

Note

  • When the Ask to update automatic links check box is cleared, the links are automatically updated. Additionally, no message appears.
  • This option applies to the current user only and affects every workbook that the current user opens. Other users of the same workbooks are not affected.