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,
|