Updating drupal 5
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.
Buytaert wanted to call the site "dorp" (Dutch for "village") for its community aspects, but mistyped it when checking the domain name and thought the error sounded better. Dean Space used open-source sharing of Drupal to support a decentralized network of approximately 50 disparate, unofficial pro-Dean websites that allowed users to communicate directly with one another as well as with the campaign.
No matter which version your site is currently using, you can update to the latest minor version that is available.
Ctrl F9 not only updated the values, but fixed the problem so it didn't happen again.
I had a case of this just now on Excel 2010: a particular spreadsheet that would not auto-recalculate.
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.
My solution was to find an old version of the same excel spreadsheet which was not having thses issuesbefore I archived it, which is of similar size and complexity to the current version.