Hi All, What is the basic difference between xlCalculationManual and Calculation = xlManual switches from the default Automatic setting. Prevent VBA Case Sensitive – Option Compare Text You can turn off automatic calculation with a macro by setting it to xlmanual.DIFFERENCE BETWEEN XLCALCULATIONMANUAL AND XLMANUAL >> READ ONLINE. application.calculation = xlcalculationmanual vba meaningxlcalculationmanual vs xlmanual. You will notice a significant difference in the run time if you deal with mass data. Calculation = xlManual Application.CalculateBeforeSave = False End