We are using Aspose.cells in our application and we are facing issue while removing external excel links. We are not able to retain data in one scenario. Please help
Attached are the two examples of different types external links.
Book2.xlsx – Contains external links created by referring data cells from a different workbook, directly from the Formula bar.
Book3.xlsx – Contains the broken links created by referring a data cells from a different workbook via Name Manager.
Please refer to the code snippet below that we have created to remove such external links.
If wbUpLoaded.HasExernalLinks Then wbUpLoaded.RemoveExternalLinks() m_TraceMessage = "Broken Links in Excel" LogTrace() wbUpLoaded.Save(m_UpFile, Aspose.Cells.SaveFormat.Excel97To2003) End If
The code properly removes the external links from Book2.xlsx and the data in the corresponding cells also gets retained. However, the same code fails to retain the data in the cell for Book3.xlsx(external links however, gets removed).
Is there a way to retain the data in the entire spreadsheet for reports which have broken links across the entire sheet (for Book3.xlsx)?