| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas Stopped Working | Excel Discussion (Misc queries) | |||
| Linked Formulas have stopped working! | Excel Worksheet Functions | |||
| formulas have stopped working automatically | Excel Discussion (Misc queries) | |||
| why formulas have stopped working in Excel? | Excel Worksheet Functions | |||
| VB Stopped Working | Excel Worksheet Functions | |||
Linear Mode
