Also note that if you open any workbook that was saved as Manual Mode, it will cause Excel to switch all workbooks open to manual, It cannot have some automatic and some manual, so the manual mode will essentially infect the other workbooks with the same setting. So make sure you switch to automatic mode, then save EVERY open workbook, close Excel, then reopen the workbook in question. It should be in automatic mode at that point.
