Why the values are not updating or calculating in Excel?

0 votes
asked Jul 13 in MS Excel Issues by PAV

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!!!

1 Answer

0 votes
answered Jul 13 by taylor (340 points)

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 
Welcome to Q&A - Repair MS Excel File, where you can ask questions and receive answers from other members of the community.
...