why don't my totals change when I enter additional data?
 

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.

why don't my totals change when I enter additional 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.

why don't my totals change when I enter additional 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.