Discussion 83 Views Sulakkya Peiris (Sulakkya) evonsys Consultant evonsys US View Profile Send Message Sulakkya Member since 2015 16 posts evonsys Posted: September 13, 2020 Last activity: September 14, 2020 Posted: 13 Sep 2020 12:57 EDT Last activity: 14 Sep 2020 7:34 EDT Suppress excel 'update links' warning- via script Report When we open a workbook which contains links or references, we will get the following warnings. Warning 1: To suppress, Go to File > Options, in the excel options dialog box, click advanced in the left pane, and then uncheck 'ask to update automatic links' under the general section, see screenshot: Warning 2: To suppress, 1. Click Data > Edit Links, 2. In the Edit Links dialog box, click 'Startup Prompt' button at the bottom, 3. And then in the prompt, choose 'Don’t display the alert and don’t update automatic links'. =================================================================================== We can achieve the same via script. (please refer to the attached .txt file) Method parameters, path - excel file path workSheet - sheet number public void hideLink(string path, int workSheet) * Make sure to set, StartOnProjectStart = false on excel. Note: Add this line before the namespace, using myExcel = Microsoft.Office.Interop.Excel; ***Edited by Moderator: Pallavi to change content type from Idea to Discussion*** Pega Robotic Automation 19.1 Robotic Process Automation Financial Services Robotics System Architect Developer Knowledge Share Reply Like (0) Share Share this page Facebook Twitter LinkedIn Email Copy link Copying... Copied!