I had a case of this just now on Excel 2010: a particular spreadsheet that would not auto-recalculate.I changed the setting as indicated above; but the auto-recalculate still did not work, and upon rechecking the "Calculation" option, found it had reset itself back to "Manual" all by itself.
However, for some reason, the value calculated by the formula does not update automatically. We already had the calculation options set to automatic and didn't know why values weren't updating.You type a formula in a cell, then you press ENTER. To fix this error and get back the values (or results) just press CTRL ` again. You check if a donut chunk went in to the key board and some how jammed the ENTER key. When you do it, excel shows the formulas instead of their results.After I change the values, the cells with formulas corresponding to cells that have been changed are not updating.When I go into excel and click on the cell with the formula, and then click in the function bar, the formula updates. Please describe the exact sequence of operations, including opening and closing the worksheet in Excel. 1) Create the worksheet; 2) Close Excel; 3) Run your Java program; 4) Reopen the worksheet in Excel? Yes, this is what used as a workaround when I noticed the issue. I will accept this answer as it technically resolves the root problem.