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);   } }