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

asked 2019-06-28 18:01:19 +0200

pnutheadedd gravatar image

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.

edit retag flag offensive close merge delete


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.

SJN gravatar imageSJN ( 2019-06-28 23:01:20 +0200 )edit