Recalculate Formula when field value changes

P

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
 
T

tim m

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