When you edit a formula, the new result is calculated automatically is not working

I have to click in the formula, hit space bar, then enter, and it will auto calculate. Otherwise it will not do it on it’s own.

I am also seeing a problem with the recalculating. I toggled the switch at Data>Calculate>AutoCalculate, some cells did recalculate but others did not. Tried the F9 key, this appeared to work on my small sheet (under 100 cells), but the auto-calculate is still not working correctly.