Forum Discussion
pokeyarw
Apr 22, 2021Copper Contributor
Formulas not computing
I have a Mac running Mojave (10.14.6) and Office 365. I periodically find that formulas in one of my files will not compute, i.e., they remain in the cell as typed rather than computing the result. ...
Riny_van_Eekelen
Apr 23, 2021Platinum Contributor
pokeyarw On a Mac myself though running Big Sur. Mojave is quite old and perhaps an upgrade helps. Can't replicate the erratic behaviour you described and have never experienced it myself. I don't believe you are accidentally switching off and on the automatic calculation mode either. Or do you?
on the Formulas ribbon.
With regards to the Find & Replace window, press ctrl-H to open it. If that doesn't work for you something is wrong indeed.