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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Function Won't Auto-Calculate 5
VBA Created Worksheet Function Not Recalculating 5
Formula, one field complex or multiple table field simple 1
slow response to change in cell 2
Name field - automatic calculate 2
Date calculations in Excel 2
use excel formula to suggest cell value, but be able to override 1
HELP! optimize calculating values 3

Top