Application.calculation = xlcalculationmanual not working

Microsoft Excel Calculation Secrets and optimisation tips, calculation methods, calculation sequence, dependencies and memory limits. The True argument does not work with Application.SendKeys. Dim oSht as worksheet Application.Calculation=xlCalculationManual. for each oSht in Worksheets Application.Calculation = xlCalculationManual not working. Excel. Details: Application.Calculation = xlCalculationManual. which sets the calculation to Manul so Excel does not go into a loop trying to calculate everything.