Excel formulas quit running

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
 
R

Rafael Ortiz

You probably checked this, but in case not, select Tools, Options,
Calculation, make sure Automatic is selected.

MRO
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top