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); } }
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
