Worksheet.EnableCalculation Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .EnableCalculation

expression A variable that represents a Worksheet object.

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.

This example sets Microsoft Excel to not recalculate worksheet one automatically.

Worksheets(1).EnableCalculation = False
Show: