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:
- Click Microsoft Office File, and then click Options.
- Click Advanced.
- Under General, click to clear the Ask to update automatic links check box. Refer Control Startup Message About Updating Linked Workbooks in Excel .
- 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.