My formula wont calculate automatically in Excel

B

Bron

For some strange reason, I can start a spreadsheet, a very simple one and do
a running total sum - it works.

Then half way through, if I go in and change a value in the same column that
was adding correctly, it ceases to add up automatically. I then have to go
back into the totalling forumla and hit enter to make it register the new
value - any ideas as to why it won't automatically add up?
 
G

garfield-n-odie [MVP]

In Excel, click on Tools | Options | Calculation tab | Automatic
| OK.
 

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