Recalculate Formula when field value changes

[patilprt]

I have an excel sheet containing formula. If I change the field value/s on which formula depend, It should recalculate value of formula field.
For this which option I should set? Or check Add In?

[tim m]

'tools'...'options'....'calculation tab....check the automatic calculation
check box.

"patilprt" wrote:

>
> I have an excel sheet containing formula. If I change the field value/s
> on which formula depend, It should recalculate value of formula field.
> For this which option I should set? Or check Add In?
>
>
> --
> patilprt
> ------------------------------------------------------------------------
> patilprt's Profile: http://www.excelforum.com/member.php...o&userid=36506
> View this thread: http://www.excelforum.com/showthread...hreadid=562631
>
>