title: Break all links in Excel workbook
body: <p>I want to break all links within an excel workbook using c# via a VSTO addin and convert the formulas to hardcoded data.</p>
  
  <p>EDIT UPDATE:
  Code iterates through each link fine but the link is not broken, the breaklink line executes but nothing happens?</p>
  
  <pre><code>Array links = (Array)((object)invoiceBook.LinkSources());
  if (links != null)
  {
  
      foreach (string link in (Array)links)
      {
          invoiceBook.BreakLink(link, Excel.XlLinkType.xlLinkTypeExcelLinks);
      }
  }
  </code></pre>