I have a cell containing complex formula which also refers itself.

my formula in cell DB10=1/(-2*LOG((2.51/CZ10*SQRT(DB10))+(DA10/(VLOOKUP(L10;'schedule select'!$A$3:$B$32;2;0)-2*S10))*0.269))^2

as you see the formula containing cell "DB10" where the formula is.

by circular reference and making iteration it calculates itself. but when I close and open the file. the cell "DB10" shows "#NAME?". when you click the cell and just click enter, then it gives the result.

Is there any way to do it automatically.