Hi Alexander,

At a guess I would say you have something wrong with your UDF. My
guess would be that somewhere in the code of the function you refer to
"ActiveSheet" or something similar. Hence, when you are on a different
sheet and change something, your UDF is recalculating, but not with
the correct info. When you switch back to the correct sheet, it does
not recalculate again, because it already did when you were on the
other sheet.

Maybe post your UDF code and we could possibly help.

Cheers,
Ivan.

On Mar 27, 7:34*pm, "Alexander_Sagiyan" <u42464@uwe wrote:
Hi, experts

Please, help me if you can.
Every time I change cell value on other worksheet than the one where
selfwritten function is called and if this cell rules any argument
calculation I'm getting 0.0 or #value. Once I put cursor into my function
calling cell and push enter it recalculates. What should I do to force it
recalculate automaticly?
I searched for my problem here and found that I should add Application.
Volatile.
It helped but only partly. Before I had to manualy recalculate (put curcor
and push enter) every cells callin my function. Now I need to do it only in
one cell and other on the same sheet recalculate.
Is it possible to recalculate my function when any cell in entire workbook
has been changed?