How do I make a formula automatically detect changes in values

G

Guest

How do I make formulas (such as summations) automatically detect when I can a
value in one or more of the cell that are included in the formula without
double clicking cell everytime I make a change?
 
G

Guest

Check tools>options>calculation tab and make sure it is set to automatic
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 

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

Creating a template that I can reproduce every month by keying ininformation from SAP 8
Maintain cell reference after value is moved 2
Searching the formula (not the value) for a text string 1
IF AND Nested Functions - Formula Not Working 0
Cell =Now() << Can I get this to auto-update? 2
Formula for selecting the greater of two values? 5
sum data in column for dates until today 3
Cells w/ user defined function do not auto update 2

Top