The CalculateFormulas method calculates any Calculation Engine Supported Formulas in the workbook. Any formulas in the workbook that are not supported by the Calculation Engine will be set as 0.

 public void CalculateFormulas()
 Public Sub CalculateFormulas()

 

 

//Create an ExcelApplication object
ExcelApplication xla = new ExcelApplication();

//Open a workbook containing formulas
Workbook wb = xla.Open("FormulasWorkbook.xlsx); 
 
//Call CalculateFormulas
wb.CalculateFormulas();
'Create an ExcelApplication object
Dim xla As New ExcelApplication
 
'Open a workbook containing formulas
Dim wb As Workbook = xla.Open("formulasWorkbook.xlsx")
 
'Call Calculateformulas
wb.CalculateFormulas()