How to refresh excel tabs

Aspose.Cells Product Family
1

hi,
Using Aspose in c#. I am adding data to destination tab, once after I finished adding, there are other Tabs which are referenced to destination tab and I am using the formula like Destination!$HL$2:INDIRECT(“Destination!HL”&Sheet_RowsCount!B1) and many other formulas. basically I am giving the range. I do not need to do anything in the other tabs excel automatically calculates everything, I am preloading the formulas.

Here comes the issue, If I am doing manually the excel working fine, but with the code Its not refreshing. how can I refresh the rest of the tabs to get the results correctly.

If any sample code would be greatly appreciable.

2

@kiran5388,

Please calculate those formulas after you updating cell values that are referenced by them. The simple code may be:
Workbook.CalculateFormula();

Please see the document at Calculate Formulas|Documentation for more details.

3

hi,
It seems like the INDIRECT formulas refresh not working on using this Workbook.CalculateFormula();

I am using the Excel 2022. I have no Idea I tried this too _SourceWorkbook.Settings.CalculationId = “0”;
And no use.

Please reply ASAP

4

@kiran5388,

Please make sure that you are using latest version of Aspose.Cells for .NET v22.11. If you still find the issue, kindly do zip and attach your template Excel file. We will check your issue soon.