Share via


Worksheet.EnableCalculation Property (2007 System)

Gets or set a value that indicates whether Microsoft Office Excel automatically recalculates the worksheet when necessary.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)

Syntax

'Declaration
<BrowsableAttribute(False)> _
Public Property EnableCalculation As Boolean
'Usage
Dim instance As Worksheet 
Dim value As Boolean 

value = instance.EnableCalculation

instance.EnableCalculation = value
[BrowsableAttribute(false)]
public bool EnableCalculation { get; set; }
[BrowsableAttribute(false)]
public:
property bool EnableCalculation {
    bool get ();
    void set (bool value);
}
public function get EnableCalculation () : boolean 
public function set EnableCalculation (value : boolean)

Property Value

Type: System.Boolean
true if Excel automatically recalculates the worksheet when necessary; otherwise, false.

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.

.NET Framework Security

See Also

Reference

Worksheet Class

Worksheet Members

Microsoft.Office.Tools.Excel Namespace