How can I get my Excel spreadsheet to automatally recalculate for.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Within my spreadsheets, when I chage data in a referenced cell, the cell with
the formula does not automatically recalculate the new sum. I distinctly
remember that it used to, and there is no way that I want to have to go to
each formula cell and click on the (greek symbot for sum) to get it to
update. Any help?
 
Barbara,

Check to see if auto calculate is enabled. Tools -> Options
->Calculation.
 
You must log in or register to reply here.

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

Similar Threads

formula recalculation in Excel 2003 - oddity? 3
Excell formula or setting to recalculate periodically. 1
how do I turn ON auto REcalculate for formulas if new data enter? 1
Automatically recalculating in Excel 2
Forcing to recalculate 7
Array formulae do not recalculate 2
Excel 2003 workbook not updating values 1
Array formulas slows spreadsheet 6

Back
Top