My formulas stopped working even though equations are correct
 

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 formulas stopped working even though equations are correct
 

1. make sure your calculation mode was not accidentally set to manual.
--
Gary''s Student - gsnu200731


"bkristal" wrote:

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 formulas stopped working even though equations are correct
 

My first guess is that calculation is set to manual.

Tools|Options|calculation tab|check automatic



bkristal wrote:

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.

--

Dave Peterson