I have to click on the formula, re-enter a digit (any one) and then hit eter
for my totals to be current after inputting additonal data.

I imagine this is a custom function you have created?

If so, add the following as the first line in the code.

Application.Volatile



MH


"Melozia" wrote in message
...
I have to click on the formula, re-enter a digit (any one) and then hit
eter
for my totals to be current after inputting additonal data.

ToolsOptionsCalculation tab, check Automatic

--
Kind regards,

Niek Otten

"Melozia" wrote in message ...
|I have to click on the formula, re-enter a digit (any one) and then hit eter
| for my totals to be current after inputting additonal data.