RecalculateAsync Method

Recalculates all formulas on the workbook.

Syntax

Visual Basic

'Declaration
 
Public Sub RecalculateAsync( _
   ByVal includeNonDirtyFormulas As Boolean _
) 

C#

public void RecalculateAsync( 
   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