Free Support Forum -

Workbook.CalculateFormula does not appear to work

When ever I open a newly created Excel file created by Aspose, Excel spends time calculating formulas. Once I save with Excel and re-open it, this behaviour stops.

Is the Workbook.CalculateFormula supposed to take care of this?

Thanks, James

Workbook.CalculateFormula is used to correctly retrieve data at run time. Aspose.Cells forces MS Excel to re-calculate formulas when opening an Excel file. This is to avoid inconsistency while meeting following issues:

1. Unsupported functions in CalculateFormula method

2. Formulas with external links

3. Add-In formulas

4. VBA formulas