Excel formulas quit running

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Have a 2-yr old spreadsheet that is used daily. Today it
will no longer carry the formulas from one cell to the
next. I have re-entered most of the formulas--saved--and
returned. The formulas were there--however when you
change a value--the formula does not change the data.

i.e. we use days to pay--we enter today's date and
subtract the due date--(formula) when I change the date,
the old information remains. Also, column adds are not
working--when I re-enter the formula--it works, but if I
change a value within the column--the data doesn't change
 
You probably checked this, but in case not, select Tools, Options,
Calculation, make sure Automatic is selected.

MRO
 
Back
Top