Version

Recalculate(Boolean) Method

Recalculates all formulas on the workbook.
Syntax
'Declaration
 
Public Overloads Sub Recalculate( _
   ByVal includeNonDirtyFormulas As Boolean _
) 
public void Recalculate( 
   bool includeNonDirtyFormulas
)

Parameters

includeNonDirtyFormulas
True to recalculate all formulas on the workbook regardless of whether they had a pending evaluation. False to only calculate dirty formulas.
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.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, 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

See Also