@dr.doc,
You may please try the following sample code using the latest version Aspose.Cells for .NET 21.3.
// Load your source excel file containing the external link
Workbook wb = new Workbook("sample.xlsx");
// Access the first external link
ExternalLink externalLink = wb.Worksheets.ExternalLinks[0];
// Print the data source of external link, it will print existing remote
// path
Console.WriteLine("External Link Data Source: " + externalLink.DataSource);
// Remove the remote path and print the new data source
// Assign the new data source to external link and print again, it will
// now print data source with local path
externalLink.DataSource = "ExternalAccounts.xlsx";
Console.WriteLine("External Link Data Source After Removing Remote Path: " + externalLink.getDataSource());
// Change the absolute path of the workbook, it will also change the
// external link path
wb.AbsolutePath = "C:\\Files\\Extra\\";
// Now print the data source again
Console.WriteLine("External Link Data Source After Changing Workbook.AbsolutePath to Local Path: " + externalLink.getDataSource());
// Change the absolute path of the workbook to some remote path, it will
// again affect the external link path
wb.AbsolutePath = "http://www.aspose.com/WebFiles/ExcelFiles/";
// Now print the data source again
Console.WriteLine("External Link Data Source After Changing Workbook.AbsolutePath to Remote Path: " + externalLink.getDataSource());
If it does not fulfill your requirement, share your sample Excel file, program output, and expected output file. Also, share the steps to achieve this requirement using MS Excel for our reference.
