Forum Discussion
Michael_GRM
Jan 23, 2023Copper Contributor
Problematic evaluation of basic formula
Hello. Im hoping someone can help me solve a very irritating problem that appears to have developed since moving to 365. I have a standard spreadsheet that I use to do some basic calculations and...
Patrick2788
Jan 23, 2023Silver Contributor
I'd start with going to Formulas menu | Error checking to see if there are any circular references holding up calculations.
Michael_GRM
Jan 24, 2023Copper Contributor
Thank you for the reply.
There are no circular references.
For formula fails to calculate randomly (what seems to be randomly)
to get the calculation to update one can press F2 to edit the cell and then enter and the cell calculates.
I can send you a version of the sheet if that is in any way helpful