Difference between xlcalculationmanual and xlmanual

application.calculation = xlcalculationmanual vba meaningxlcalculationmanual vs xlmanual

Hi All, What is the basic difference between xlCalculationManual and Calculation = xlManual switches from the default Automatic setting.Calculation Case xlManual Application.Calculation = xlCalculationAutomatic MsgBox "Automatic Calculation Mode" Case xlAutomatic Application. You will notice a significant difference in the run time if you deal with mass data. Calculation = xlManual Application.CalculateBeforeSave = False End Note: there is another suggested explanation as 'Excel copy loosing the focus'; it might be just a semantic difference, pointing to the same effect and just