Forum Discussion
Howard Coffinger
Aug 10, 2018Copper Contributor
Formulas have quit working
The formulas in my worksheet have quit functioning. All are very simple add/subtract.
Philip West
Aug 10, 2018Steel Contributor
Have you accidently changed the cells the formula are in to Text, or changed the sheet to manual calculation (formula ribbon->calculation options)
Howard Coffinger
Aug 11, 2018Copper Contributor
I don't believe so. How would I check?
- SergeiBaklanAug 11, 2018Diamond Contributor
In ribbon as Philip mentioned or File->Options->Formulas and be sure Automatic is selected
- Howard CoffingerAug 11, 2018Copper Contributor
THANK YOU GENTLEMEN!!! Problem solved. Appreciate your help.
- SergeiBaklanAug 11, 2018Diamond Contributor
You are welcome