Excel is not updating formulas

Posted by / 05-Dec-2017 09:54

Instead the formula only updates after the formula is edited or the spreadsheet is closed and opened again.

If you make some modifications to an Excel file and then close it without saving, it will ask you whether you want to save the changes.If you find this feature annoying, you can also close it.To make the data more accurate in the workbook, you need to change in Excel options.Now you check the “Manual”, only when you manually recalculate the worksheet (Press F9) or workbook (Press Shift F9), the formula will recalculate.Hence, you need to decide whether to check the option according to your actual need.

excel is not updating formulas-90excel is not updating formulas-5excel is not updating formulas-34

Besides, this setting only takes effect in the current workbook, so it will not affect other Excel files.