Why the values are not updating or calculating in Excel?

Question

I am using Excel 2016 and I try a very simple formula. But I don’t know what goes wrong the values are not updating or calculating in Excel.

I checked the formula twice but found nothing. And anyone suggests me some tips to fix the values are not updating or calculating in Excel? Thanks in advance!!!

Answer 1

Well, the only thing that is causing the Excel error is your Excel results are apparently wrong. Maybe you have changed something but results are still the same, Excel is not updating the results?  

In this case, it is possible your workbook is set to manual calculation and Excel recalculates the workbook only at the time when you ask it to do so.

• Hit F9 and this allow all the changed formulas and their depending cells will be recalculated
• However, in many cases, pressing F9 does not solve the issue. Hit Ctrl + Alt + F9 on the keyboard. In this way, all formulas – no matter they are changed or not would be recalculated.
• Hope the issue is resolved 

To know more read this: http://www.repairmsexcel.com/blog/9-top-fixes-solutions-excel-formulas-not-working-error