updating formulas

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

Guest

I have excel 2003, I am having problems with my formulas. When I imput new
data my formulas are not updating. I have to actually double click in the
cell that contains the formulas and hit enter. How can I fix this problem?
 
Goto Tools|Options|Calculation
Make sure Automatic is selected and not manual
 
Ok, thanks, so how do you set to automatic? I am not sure about this. Thanks
 
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

Protecting select cells 2
Can't choose an imput cell for my data table in another worksheet 1
solving nested IF statements 13
Excel Formula Issues 1
Trailing 30 days sum calculation with excel 1
Excel 2003 worksheet doesn't auto calculate 4
ambiguous name detected? 7
Spreadsheet won't recalculate when numbers are changed. 1

Back
Top