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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 05:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com