Excel formula not updating automatically A1 adult chat
A sum that is not updating automatically in Excel 2013 can be frustrating and, depending upon the importance of the information that it affects, potentially dangerous.
But Excel 2013 has a manual calculation option as well, and it can switch from automatic to manual in some situations.
This happens when Excel has been configured to NOT update formulas automatically.
This setting applies to the program for the logged in user – so all spreadsheets will have the same issue.
It is not just for addition or AUTOSUM formulas that are not updating automatically.
Step 1: Open the workbook with the formula that is not updating.