Problem with summing formula updating Total...
 

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,

Problem with summing formula updating Total...
 

ToolsOptionsCalculation tab, check "Automatic"

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dave" wrote in message ...
|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,
|

Problem with summing formula updating Total...
 

THANKS!!!! Saved me a huge headache!!

"Niek Otten" wrote:

ToolsOptionsCalculation tab, check "Automatic"

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dave" wrote in message ...
|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,
|