software

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
MHquot;Meloziaquot; gt; wrote in message
...
gt;I have to click on the formula, re-enter a digit (any one) and then hit
gt;eter
gt; for my totals to be current after inputting additonal data.
Toolsgt;Optionsgt;Calculation tab, check Automatic

--
Kind regards,

Niek Otten

quot;Meloziaquot; gt; 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.