Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When chenging one of the formula inputs, the result is not updated. Why?
Hi. I have never had this problem before. All of a sudden, my excel does not update formulas by itself. I need to press F9 every time I change a formula input for get a new result. This happedned two days ago on both my laptop and my desktop after I was working on some files I got from a client. What whould be the reason for this, and how do I fix. Thanks, Skrepka -- skrepka ------------------------------------------------------------------------ skrepka's Profile: http://www.excelforum.com/member.php...o&userid=36596 View this thread: http://www.excelforum.com/showthread...hreadid=563383 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
When chenging one of the formula inputs, the result is not updated. Why?
skrepka Wrote: Hi. I have never had this problem before. All of a sudden, my excel does not update formulas by itself. I need to press F9 every time I change a formula input for get a new result. This happedned two days ago on both my laptop and my desktop after I was working on some files I got from a client. What whould be the reason for this, and how do I fix. Thanks, Skrepka Check Tools - Options.... Goto the Calculation tab. Make sure "Automatic" is selected and hit OK. Scott -- Maistrye ------------------------------------------------------------------------ Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078 View this thread: http://www.excelforum.com/showthread...hreadid=563383 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
When chenging one of the formula inputs, the result is not updated. Why?
Scott, thank you very much. I guess this was an easy fix, but I would have never known about it. Now its working perfect. Skrepka -- skrepka ------------------------------------------------------------------------ skrepka's Profile: http://www.excelforum.com/member.php...o&userid=36596 View this thread: http://www.excelforum.com/showthread...hreadid=563383 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The Formula is displaying, not the result | Excel Discussion (Misc queries) | |||
Rs.10,250.00 formula Rupees ten thousand two hundred fifty only | New Users to Excel | |||
How do I make a formula read a result rather than a formula | Excel Discussion (Misc queries) | |||
Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |