SUM not updating automatically


G

Guest

Hi! I am using Excel 2003. I have a document with lists of numbers that are
totalled with =SUM at the bottom, such as =SUM (E4:E14) . I frequently
change the numbers in the lists throughout the day and the totals
automatically update based on my changes. I have been using this document for
weeks with no problem. As of this morning, for no reason I can determine, the
totals no longer update automatically. If I change the numbers in any list,
the sum stays the same until I enter the relevant SUM cell and exit it again.
I don't have to make any changes to it, I simply have to enter and exit it.
(I double-click, then hit Esc.) Once I do that, it corrects the total...
until the next time I change a number, and then I have to do it all over
again. Any ideas on how to fix this? Thanks so much!
 
Ad

Advertisements

G

Guest

check tools>options calculation tab and calculation is set to automatic
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
G

Guest

John, you're wonderful. I have no idea how that option got turned off - I've
never visited that tab in my life. But it fixed the problem - of course - and
everything's right as rain again. Thanks so much! I just love when it's an
easy fix. ;)
 
Ad

Advertisements

G

Guest

Glad to be able to help
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 

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


Top