Excel Formula Not Calculating: Just Showing Formula | Formulas Not Calculating Automatically

In this video, I demonstrate four ways of getting your formula to correctly and automatically calculate. The four reasons that they might not be calculating are:

1) Formulas are entered or formatted as text values
2) Calculation mode is set to manual rather than automatic
3) The 'Show formulas' setting has been turned on
4) You have a circular reference
------------------------

[gloriaadjartey]

In less than 3 mins, you have given the solution to a problem i have spent months to find a solution thank You so much...i wish i could give a billion likes....

[rayjansma]

Thank you, Thank you, thank you. Fairly complicated calculations for invoicing a client and couldn't understand why the formulas were suddenly not working. Called a couple of my Excel "experts, " and they had no idea. Turns out it was reason number 3 in your video, the "calculation options" had somehow been switched to manual. Off and running now.
Thanks again.

[marieeakin]

Thank you! Per another comment I am no longer beating my head against my desk.
For me it was the text to column tip. I knew about three of the tips... and now I know four! THNAK YOU.

[taiekehaughton]

Thanks. This helps. It was the first thing you mentioned.

[lenka]

Brilliant. I have just found my new source for Excel questions. Thanks!

[drscyle]

You fixed my problem in less than 30 seconds. Thanks!

[juliomoreno]

Thank you!!! It worked! And the best part to listen to your great British accent!

[emilykasuya]

You saved me from spending extra time and possibly doing unpaid over time again.. THANK YOU!!!

[kgosingakane]

One method I found to be extremely useful is by finding and replacing the = signs. I've been struggling with this for a couple of weeks because by default my formulas were set to automatic in the formula tab and I just could not understand why after switching them to manual and having to double click each cell, the correct formula values would then appear. Bear in mind my dataset had about 28 thousand and some odd records and having to double click each cell just wasn't viable because I had to do the same for about four more columns (i.e., 28k * 4 ≈ 112 k), so for me the method I'd suggest is by finding and replacing the = signs if you're working with big data. And to avoid excel from not crashing, select about 500 cells and do the find and replace operation...a bit tedious but it works!

[FreyaNyeinKhinSan]

Explanation is complete & perfect.
Thanks so much

[celine]

Thank you! Your video was really helpful and resolved an issue I was having with a formula! Thank you.

[davidchick]

You finally stopped me from banging my head against the wall, thank you very much!!

[medCherkaoui]

Thank u sir it solved my problem <3

[rohitt]

It was really helpful for me. Thanks alot.

[bonganim]

Thank you, text to column did the trick. 🙌

[TheAlhumam]

Thanks a lot. My formula was to pull some text and it was selected as 'text'. I switched to General and it started to work.

[divine-favouranigbogu]

OMggg thank you. It was the space... and It was so unnoticable.

[saquibsher]

explained very well. Thanks Chester . really loved it ❣

[info-austinconvoclass]

really helpful and super understandable, thank you!

[barborahoufkova]

THANK YOU SO MUCH! The second case helped me a lot :)