Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas aren't updating when values change
Is this a sign of my excel program being corrupt or something else?
Whenever i change a value that is involved in a formula, the result does not update with the new value. For example, a very basic example is if i put 50 in A1 and 50 in A2, then create a formula in another cell to be A1+A2 the result in that cell would be 100. Now if i change the value in A1 to be 25, the formula cell should change to read 75. Mine does not automatically - it still reads 100 after the change even thought clearly A1 + A2 should read 75. I have to retype in my formula a second time in order for the value update to occur. Please if you someone could offer some feedback. Thanks. Andrew K. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas aren't updating when values change
Tools/ Options/ Calculation
Set to Automatic, not Manual. -- David Biddulph "Andrew K." <Andrew wrote in message ... Is this a sign of my excel program being corrupt or something else? Whenever i change a value that is involved in a formula, the result does not update with the new value. For example, a very basic example is if i put 50 in A1 and 50 in A2, then create a formula in another cell to be A1+A2 the result in that cell would be 100. Now if i change the value in A1 to be 25, the formula cell should change to read 75. Mine does not automatically - it still reads 100 after the change even thought clearly A1 + A2 should read 75. I have to retype in my formula a second time in order for the value update to occur. Please if you someone could offer some feedback. Thanks. Andrew K. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas aren't updating when values change
It sounds as if you have manual calculations on
Go to Tools|Options, Calculation tab, and ensure automatic calculations is checked. NOTE: Whenever you open excel the first time, that particular spreadsheet determines the calculation environment. So if you open a spreadsheet that has manual calc on, any subsequent spreadsheets you open while you still have excel open will switch to manual calc. -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Andrew K." wrote: Is this a sign of my excel program being corrupt or something else? Whenever i change a value that is involved in a formula, the result does not update with the new value. For example, a very basic example is if i put 50 in A1 and 50 in A2, then create a formula in another cell to be A1+A2 the result in that cell would be 100. Now if i change the value in A1 to be 25, the formula cell should change to read 75. Mine does not automatically - it still reads 100 after the change even thought clearly A1 + A2 should read 75. I have to retype in my formula a second time in order for the value update to occur. Please if you someone could offer some feedback. Thanks. Andrew K. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas aren't updating when values change
Thank you very much, that solves the issue.
"John C" wrote: It sounds as if you have manual calculations on Go to Tools|Options, Calculation tab, and ensure automatic calculations is checked. NOTE: Whenever you open excel the first time, that particular spreadsheet determines the calculation environment. So if you open a spreadsheet that has manual calc on, any subsequent spreadsheets you open while you still have excel open will switch to manual calc. -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Andrew K." wrote: Is this a sign of my excel program being corrupt or something else? Whenever i change a value that is involved in a formula, the result does not update with the new value. For example, a very basic example is if i put 50 in A1 and 50 in A2, then create a formula in another cell to be A1+A2 the result in that cell would be 100. Now if i change the value in A1 to be 25, the formula cell should change to read 75. Mine does not automatically - it still reads 100 after the change even thought clearly A1 + A2 should read 75. I have to retype in my formula a second time in order for the value update to occur. Please if you someone could offer some feedback. Thanks. Andrew K. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas aren't updating when values change
Thank you for the feedback, and don't forget to mark YES that your question
has been answered :) -- ** John C ** "Andrew K." wrote: Thank you very much, that solves the issue. "John C" wrote: It sounds as if you have manual calculations on Go to Tools|Options, Calculation tab, and ensure automatic calculations is checked. NOTE: Whenever you open excel the first time, that particular spreadsheet determines the calculation environment. So if you open a spreadsheet that has manual calc on, any subsequent spreadsheets you open while you still have excel open will switch to manual calc. -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Andrew K." wrote: Is this a sign of my excel program being corrupt or something else? Whenever i change a value that is involved in a formula, the result does not update with the new value. For example, a very basic example is if i put 50 in A1 and 50 in A2, then create a formula in another cell to be A1+A2 the result in that cell would be 100. Now if i change the value in A1 to be 25, the formula cell should change to read 75. Mine does not automatically - it still reads 100 after the change even thought clearly A1 + A2 should read 75. I have to retype in my formula a second time in order for the value update to occur. Please if you someone could offer some feedback. Thanks. Andrew K. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas Aren't Automatically Updating When Cells Change | Excel Discussion (Misc queries) | |||
How do I change the Sheet name without updating formulas? | Excel Discussion (Misc queries) | |||
Updating Values For Custom Formulas | Excel Discussion (Misc queries) | |||
Formulas not recalculating when values change on another sheet | Excel Worksheet Functions | |||
is there a way to change formulas to values for sorting purposes? | Excel Worksheet Functions |