How can I make a function calculate automatically?
Posted by GLITZ on December 28, 2000 1:46 PM
I've got a function that refers to a range of data to produce an answer.
If a cell in the refered to range changes, the function's answer doesn't update.
F9 doesn't work.
If I hit F2 and then enter on the cell with the function in it, the cell will then update.....
Am I missing something?
What do I need to change?