My formulas stopped working even though equations are correct

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a template spreadsheet (main copy) I have used for years. In this
appraisal I copied a working copy into the main copy and then deleted the
working copy. All of a sudden many of my formulas stopped working. eg.
a5*c5 gives a blank space instead of the correct number. Also, my addition
formulas stopped working. This is weird.
 
My first guess is that calculation is set to manual.

Tools|Options|calculation tab|check automatic
 
Back
Top