Go to
Tools-Options, Calculation
Select automatic.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Marcus" wrote:

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