My excel no longer calculates right when I copy formulas

S

Saga3

My spreadsheet is no longer able to calculate the correct answer when I copy
a formula from 1 cell to another. Or even when I change the value in a cell
it does not change the answer. It seems to work fine when I put the formula
in the specific cell, but if I copy it from elsewhere into it, it does not
work.
 
D

Dave O

It sounds like you may have inadvertently toggled Calculation to
manual. From the menu click >Tools >Options and on the Calculation tab
select Automatic, then press OK.
 
Top