Question description:
This user has given permission to use the problem statement for this
blog.
Recently Excel stopped recognizing when I'd change a value in a formula. For example, I'd have five numbers summed in a formula... 1+2+3+4+5=15. If I change any of the inputs, for example changing 1 to 0, thus 0+2+3+4+5, it still equals 15, unless I go in and edit the formula. Help!
Solved by C. J. in 6 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
29/08/2018 - 03:25
Hello
Excelchat Expert
29/08/2018 - 03:25
How are you today?
User
29/08/2018 - 03:25
Hi
User
29/08/2018 - 03:25
Good and you?
Excelchat Expert
29/08/2018 - 03:25
I am great, thank you!
Excelchat Expert
29/08/2018 - 03:25
I read the description
Excelchat Expert
29/08/2018 - 03:26
Here is what we need to do.
Excelchat Expert
29/08/2018 - 03:26
1. On the ribbon - go to Formulas
User
29/08/2018 - 03:26
OK
Excelchat Expert
29/08/2018 - 03:26
2. Under the Calculation - Select Calculation Option
Excelchat Expert
29/08/2018 - 03:27
3. Select Automatic
Excelchat Expert
29/08/2018 - 03:27
and then check if formula works
User
29/08/2018 - 03:28
Just a sec
Excelchat Expert
29/08/2018 - 03:28
Sure
User
29/08/2018 - 03:30
That seems to work. I don't know why it changes, I didn't make any changes to the setting.
User
29/08/2018 - 03:30
Regardless, thank you!
Excelchat Expert
29/08/2018 - 03:30
The pleasure is all mine
Excelchat Expert
29/08/2018 - 03:30
Also, if you are satisfied with my solution, please go ahead and end the session using the button on the top right hand side and requesting you to provide good feedback and review so that I can continue my services to others.
User
29/08/2018 - 03:30
You bet!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.