Hi,

If you are using 2007 choose Formulas tab, Calculation group, Calculation
Options, Automatic

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Marcus" wrote in message
...
The problem i am having is i have a excel file with sum formulas entered.
When i enter in a value and hit the tab or enter key the formula will not
add
that value to the total. The only way to get the data to populate is to
hit
the F9 key or click the Save button and the totals appear.

Am i missing something? I would like the user to enter in data then tab
to
the next column and populate the entered data automatically.

Any help would greatly appreciated.

TIA

Marcus