title: Turn Off Msg for Update Links for Excel Spreadsheet upon Opening
body: <p>I have a workbook that I would like to open and not have it ask to update links, (exact message is :</p>
  
  <p>"This workbook contains links to other data sources. If you update the links, Excel will attempt to retrieve the latest data. If you odon't update the links, Excel will use the previous information. Note that data links can be used to access and share confidential information without your permission and possibly perform other harmful acts. Do not update the links if you do not trust the source of this workbook." ) </p>
  
  <p>What I would like to do is open the workbook by clicking on the file in Internet Explorer and have the links update but not ask for the user to click the button to update.</p>
  
  <p>I have tried the following code in the Open Event for the work book with not success:</p>
  
  <pre><code> Private Sub Workbook_Open()
       Application.DisplayAlerts = False
       Application.ScreenUpdating = False
   End Sub
  </code></pre>
  
  <p>I have also tried the following lines of code in the above Sub:</p>
  
  <pre><code>ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.FullName, Type:=xlExcelLinks
  Application.ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.FullName, Type:=xlExcelLinks
  Application.ActiveWorkbook.UpdateLink
  Workbooks.Open ActiveWorkbook, UpdateLinks:=True
  ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources, Type:=xlExcelLinks
  </code></pre>
  
  <p>The version of MS Excel 2010 and saving to an .xls file for sake of those with legacy versions.</p>
  
  <p>Your help would be very appreciated. Thank you in advance for all your help.</p>
  
  <p>Respectfully,</p>
  
  <p>Robert</p>