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