Android error updating database
What I found to be the problem was the formula and the fact that I surrounded numbers with quotes.That probably turned the cell into a text format cell, even though technically the cell was still a number and listed as one under the formats.I also have had this problem with a very large spreadsheet that just stopped updating itself over the weekend, but having checked the above solutions, setting were already set to automatic, and sheet is too big to rebuild, so I was at a loss.
I suspect that your problem and its solution were different from the one in this question.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.Three attempts later and it was still adamant it wanted to be "Manual" and nothing else.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.I am having to click on the formula bar, then I have to click enter for the formula cell to do its thing. F9 and Shift F9 didn't help and left the values the same.
Search for android error updating database:
Ctrl F9 not only updated the values, but fixed the problem so it didn't happen again.