My excel no longer calculates right when I copy formulas
 

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.

My excel no longer calculates right when I copy formulas
 

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.