Break the Data Links in an Excel Workbook

Break the Data Links in an Excel Workbook

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

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist