Feb 14 2019 04:10 AM
unable to set the workbook calculation to automatic mode, every time I open xls it's set Manual mode
Feb 14 2019 07:08 AM
Feb 14 2019 08:24 AM
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.