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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula refresh 6
Overwriting a cell with a formula without deleting the formula 1
Refrencing another cell in a worksheet that "could" exist 1
using the =page! feature to transpose a row to column 0
product formula not totaling 4
Why won't target cell data changes trigger formula evaluation? 3
Data Validation, Identify Duplicates and Limit imput 7
I have a worksheet 1

Back
Top