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

M

Melozia

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.
 
M

MH

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
 
N

Niek Otten

Tools>Options>Calculation tab, check Automatic

--
Kind regards,

Niek Otten

|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.
 
Top