Worksheet.EnableCalculation (Excel)

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

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.

ActiveSheet.EnableCalculation = True