Why does Excel not auto-update my equations anymore? [duplicate]
Check to make sure Automatic Calculation is still selected. Go to Formulas->Calculation->Calculation Options and select "Automatic".
Try changing the format type of the calculated cell from "Text" to "General" and then re-enter the formula. That fixed the problem when I was seeing these symptoms.