Recalculate(Boolean) Method

'Declaration
 
Public Overloads Sub Recalculate( _
   ByVal includeNonDirtyFormulas As System.Boolean _
) 

public void Recalculate( 
   System.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.

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.

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

Reference

Workbook Class
Workbook Members
Overload List
CalculationMode Property
RecalculateBeforeSave Property