|
|
|
|
|
|
|
|
<xlsDocument variable>.RecalculateAll (Function) In french: <Variable xlsDocument>.RecalculeTout Recalculates all formulas in an Excel (XLSX) document. MyDocument is xlsDocument
// Make changes to the XLSX document
MyDocument[1,"A"] = 1
// Define the formula
MyDocument[1,"B"].Formula = "A1"
// Recalculates all formulas
MyDocument.RecalculateAll() Syntax
<Excel document>.RecalculateAll()
<Excel document>: xlsDocument variable Name of the xlsDocument variable used. Remarks - Changing the value or formula in a cell does not automatically recalculate the formulas in the workbook.
- <xlsDocument variable>.RecalculateAll must be called after changing the value or formula of one or more cells. It updates the values of the cells of the workbook that uses a formula.
- This function cannot be used on an XLS document.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|