Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
don't update excel formula in excel worksheet?
don't update excel formula in excel worksheet, when i change the value, previous calculate value not update? what the reason? please help me.
Example: a b c
Previous = 3 + 2 = 5
Change = 4 + 3 = 5 (don't update)
A B C
1 3 2 =SUM(A1:B1), Result = 5
1 4 3 =sum(A1:B1), Result = 5 (When change A1 & B1 Value)
3 Answers
- IXL@XLLv 71 decade agoFavorite Answer
Look in Tools>Options>Calculation>select Automatic
Just before you do this press the F9 key and see if it recalculates. If it does, do above. (for 2003)
- 5 years ago
With your spreadsheet open, choose instruments, choices and Calculation. Verify the button to calculate now. Be certain these settings are how you wish to have it (automatically calculates or not, and so forth.). Hope that helps.
- RoniLv 41 decade ago
your C1 cell should contain the formula " =A1+B1". If not then you would not get your computation.
