Problem with Excel summing formula updating Totals...

G

Guest

I just purchased a new computer and it came with Office 2003 on it. I've
used XP and all previous versions of office, so I'm a little confused by what
is happening.

I have a excel document that I use to track the cash for our company. The
formula looks something like this. In cell F1 it says =A1+B1-C1+D1-E1 Then
lets say If F1 is returning 6 which is = 4+4-2+2-2 from the other cells. In
the older versions of Excel if I were to chance any of the cells say B1 to 0
instead of leaving it at 4 my total in F1 should automatically update to 2.
=4+0-2+2-2. But with 2003 when I try to change any of the cells within the
chain the total doesn't update. I have to actually click on the cell (F1)
push the F2 key to see the cells and then press enter in order for it to
calculate it correctly. Is this some new feature that 2003 has? I have no
idea why it would be considered helpful, because it creates far more work.

Please Help!

Thanks,
 
G

Guest

Check to see if Automatic Calculations is turned on.

TOOLS
OPTIONS
CALCULATION Tab
Check "Automatic"
OK

This is not a new feature, it existed in prior versions of Excel. You
probably just always had it set to automatic before.

HTH,
Elkar
 
G

Guest

I have the same issue and I have tried this solution and it does not work.
Any other ideas would be helpful? Thanks.

Stephanie
 

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