'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