Switch Excel to Manual Useful for when you have a big Excel workbook |
Application.Calculation=xlManual Application.CalculateBeforeSave=False Application.AutoRecover.Enabled=False ActiveWorkbook.UpdateRemoteReferences=False ActiveWorkbook.SaveLinkValues=False |