Recalculate() Method

Recalculates all dirty formulas pending a calculation on the workbook.

Syntax

Visual Basic

'Declaration
 
Public Overloads Sub Recalculate() 

C#

public void Recalculate()

Remarks

This can be used when the CalculationMode is Manual. In Manual mode, when cells are dirtied, formulas referencing those cells will not be recalculated until Recalculate is called or RecalculateBeforeSave is True and the workbook is saved.

To force a recalculation of non-dirty formulas, use the Recalculate(Boolean) overload and specify True for the includeNonDirtyFormulas parameter.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2