Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
The Formula is displaying, not the result tcarp Excel Discussion (Misc queries) 6 January 30th 07 06:51 AM
Rs.10,250.00 formula Rupees ten thousand two hundred fifty only Abdul Hameed ([email protected] New Users to Excel 2 June 28th 06 10:33 AM
How do I make a formula read a result rather than a formula Chris Excel Discussion (Misc queries) 7 June 20th 06 10:56 PM
Median result used in formula gives incorrect result vlatham Excel Worksheet Functions 4 September 21st 05 04:26 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM


All times are GMT +1. The time now is 11:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"