_Worksheet.EnableCalculation Property

True if Microsoft Excel automatically recalculates the worksheet when necessary. False if Excel doesn't recalculate the sheet. Read/write Boolean.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property EnableCalculation As Boolean
    Get
    Set
'Usage
Dim instance As _Worksheet
Dim value As Boolean

value = instance.EnableCalculation

instance.EnableCalculation = value
bool EnableCalculation { get; set; }

Property Value

Type: System.Boolean

Remarks

When the value of this property is False, you cannot request a recalculation. When you change the value from False to True, Excel recalculates the worksheet.

See Also

Reference

_Worksheet Interface

_Worksheet Members

Microsoft.Office.Interop.Excel Namespace