We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Change ExternalLink to a internal worksheet


I need to change the cells formulas to target a new internal worksheet.
I´ve tried to get a substring from the original formula and set it up in the cell (because the source worksheets have the same name) but the excel file turns in a corrupted file.
Is there a correct ways to do this?

PS: The source is on a network folder and need to be updated many times. We will copy it to a internal worksheet on the excel files to be able to update values on the sources without need to open the excel files to update the links.

I hope that’s clear enough.



Thanks for providing us some details.

We need to evaluate your code and template file. Please create a simple console application (runnable), zip the project and post us here to show the issue, we will check it soon.

PS. please zip the project/file(s) prior attaching.

Thanks for replying.

It is a simple project. Here I try to change the datasource to reference the internal spreadsheet.

DataSourceUpdater.zip (5.8 MB)


Thanks for the sample code and template file.

Well, you are using some older version which might have this issue. I have tested using our latest version/fix and it works fine and I do not find any issue with the output file. Please upgrade to latest version of the product and try our latest version/fix (e.g Aspose.Cells for Java v19.11.5)
aspose-cells-19.11.5.zip (6.7 MB)

Let us know your feedback.

Thank you for the reply. I’ll try it.