External workbook link data is not updating

Aspose.Cells Product Family
1

Hi Team,
I have a workbook that contains links to multiple external workbooks. When I use the CalculateFormula() the latest data from the external workbooks is not updated in the copied workbook.
Is there any other configuration required to updated external workbook link data?
Below is my code.
Test.zip (12.4 KB)

string filePath = @“D:\Test.xlsx”;
Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook(filePath);
workbook.CalculateFormula();
workbook.Save(filePath);

2

@Coder365
To update the external data with your external data source, please use CalculationOptions.LinkedDataSources:

            Workbook workbook...
            CalculationOptions copts = new CalculationOptions();
            copts.LinkedDataSources = new Workbook[] { new Workbook(@"D:\Ext_1.xlsx") };
            workbook.CalculateFormula(copts);