I will keep updating

05 Jul

I am having to click on the formula bar, then I have to click enter for the formula cell to do its thing. 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.

I checked all the normal things, like cell type, auto calculation, etc...

What I found to be the problem was the formula and the fact that I surrounded numbers with quotes.

The default value for minimum healthy percent is 50% in the console and 100% for the AWS CLI, the AWS SDKs, and the APIs.

The maximum percent parameter represents an upper limit on the number of your service's tasks that are allowed in the state during a deployment, as a percentage of the desired number of tasks (rounded down to the nearest integer).

Somehow PI's Calculate method was no longer running during the normal workbook recalculate.

If you update the task definition for the service, the container name and container port that were specified when the service was created must remain in the task definition.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.