LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
 
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
Formulas Aren't Automatically Updating When Cells Change chris Excel Discussion (Misc queries) 6 April 5th 23 02:51 PM
How do I change the Sheet name without updating formulas? [email protected] Excel Discussion (Misc queries) 4 August 15th 08 07:14 PM
Updating Values For Custom Formulas FARAZ QURESHI Excel Discussion (Misc queries) 2 January 21st 08 09:13 AM
Formulas not recalculating when values change on another sheet Bill Excel Worksheet Functions 0 September 15th 05 10:29 PM
is there a way to change formulas to values for sorting purposes? Change formulas to values Excel Worksheet Functions 3 September 2nd 05 05:15 AM


All times are GMT +1. The time now is 11:54 PM.

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

About Us

"It's about Microsoft Excel"