title: How to suppress Update Links warning?
body: <p>I'm trying to write a script that opens many Excel files.  I keep getting the prompt:</p>
  
  <pre><code>This workbook contains links to other data sources.
  </code></pre>
  
  <p>I want to keep this message from appearing, so that my script can just automatically go through all the workbooks without me having to click <code>Don't Update</code> for each one.  Currently I'm using the following:</p>
  
  <pre><code>function getWorkbook(bkPath as string) as workbook
  
  Application.EnableEvents=False
  Application.DisplayAlerts=False
  getWorkbook=Workbooks.Open(bkPath,updatelinks:=0,readonly:=false)
  
  end function
  </code></pre>
  
  <p>However, the message is still appearing.  How can I suppress it?</p>
  
  <p>EDIT: It appears that this message is coming up for workbooks that have broken links; I wasn't seeing the <code>This workbook contains one or more links that cannot be updated</code> message because I'd set <code>DisplayAlerts</code> to false.  The workbooks are linked to equivalent files in a folder on our Windows server, so when the matching file is deleted from that folder (which happens as part of our business flow), the link breaks.  Is it possible to suppress the warning when the link is broken?</p>
  
  <p>Also, I'm using Excel 2010.</p>