Custom functions not updating when dependant cells are edited
Hi
I have a problem where I use a custom function that analyses data in other
cells. When the contents of the other cells are edited the cell that uses the
custom function does not automatically update. The only way that it updates
is if you click on the cell then click on the function and click enter again.
Is there a way that the result of the cell with the custom function can
automatically update when the other cells are edited?
Thanks
|