Updating the database
However, with the advent of Microsoft's SQL Server 2008 and Esri support for the built-in SQL Server 2008 spatial data types, real-time updating of Arc SDE feature classes in SQL Server 2008 has gotten easier.
By utilizing the SQL Server geometry and geography data types, SQL stored procedures, and triggers, we can essentially bypass the Esri Arc SDE stack and push attribute and spatial updates directly to nonversioned feature class tables.
Your use of Stack Overflow’s Products and Services, including the Stack Overflow Network, is subject to these policies and terms. However, for some reason, the value calculated by the formula does not update automatically.Three attempts later and it was still adamant it wanted to be "Manual" and nothing else.Copy the contents of the spreadsheet to a new one, and deleted the old one (it wasn't a particularly important spreadsheet, thankfully), and everything was fine.I can only assume that somehow the file had become corrupted.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.