Use this function to break the data links in an Excel workbook. It shows a message asking the user to confirm to break.
private void BreakDataLinks(Excel._Workbook wb){ if (DialogResult.Yes == MessageBox.Show(this,"Do you want to break the links to Data Sources ?", "Links", MessageBoxButtons.YesNo)) { Array links = (Array)wb.LinkSources(Excel.XlLink.xlExcelLinks); if (links != null) { for (int i = 1; i { wb.BreakLink((string)links.GetValue(i), Excel.XlLinkType.xlLinkTypeExcelLinks); } }