Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
my "if" statements do not update
I have a spreadsheet full of IF statements linked to another sheet in an
excel document. Unfortunately all the IF formulas will not update when the condition is met. When i attempt to check a formula, open the cell's formula but don't change anything, then the formula updates. My question is if there is a way to make all of these formulas update without clicking on each formula. I am sure it is something simple. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
my "if" statements do not update
Tools - Options - Calculation (tab) - Select Automatic (probably manual
right now) -- HTH... Jim Thomlinson "bsze" wrote: I have a spreadsheet full of IF statements linked to another sheet in an excel document. Unfortunately all the IF formulas will not update when the condition is met. When i attempt to check a formula, open the cell's formula but don't change anything, then the formula updates. My question is if there is a way to make all of these formulas update without clicking on each formula. I am sure it is something simple. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
my "if" statements do not update
hi
try hitting the F9 key. that forces re-calculation Regards FSt1 "bsze" wrote: I have a spreadsheet full of IF statements linked to another sheet in an excel document. Unfortunately all the IF formulas will not update when the condition is met. When i attempt to check a formula, open the cell's formula but don't change anything, then the formula updates. My question is if there is a way to make all of these formulas update without clicking on each formula. I am sure it is something simple. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
my "if" statements do not update
Check ToolsOptionsCalculation and see that the calculation mode is set to
Automatic. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "bsze" wrote in message ... I have a spreadsheet full of IF statements linked to another sheet in an excel document. Unfortunately all the IF formulas will not update when the condition is met. When i attempt to check a formula, open the cell's formula but don't change anything, then the formula updates. My question is if there is a way to make all of these formulas update without clicking on each formula. I am sure it is something simple. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Need more than 7 nested "IF" statements in Excel" | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Combining "AND" with "OR" Statements | Excel Worksheet Functions |