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.
It sounds like you may have inadvertently toggled Calculation to
manual. From the menu click gt;Tools gt;Options and on the Calculation tab
select Automatic, then press OK.
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.
It sounds like you may have inadvertently toggled Calculation to
manual. From the menu click gt;Tools gt;Options and on the Calculation tab
select Automatic, then press OK.
文章標籤
全站熱搜
