5 Reasons Why your Excel Formula is Not Calculating

5 reasons why your Excel formula is not calculating, or not updating.

This video tutorial walks you through the different factors that can prevent an Excel formula from calculating. Each example is explained and you are shown how to solve the problem.

The things for the video are;
00:00 - Excel formulas set to update automatically
01:22 - Cell is formatted as text
02:37 - Common mistakes when writing the formula
04:36 - how Formulas setting is turned on
05:50 - Summary of the different reasons

Find more great free tutorials at;

Connect with us!

[beingmahdi]

Thank u so much...this video's solved my problem just in 2 second, and I was trying to fix problems from weeks ❤️❤️❤️

[vivb]

I was literally working on this for
FIVE HOURS and you resolved it in less than a minute! God bless you!

[yooperlooper]

THANKS! I had it fixed in the first 30 seconds. Great

[Contraversialful]

Hi mate wondering if you could help me out, i have imported web data onto another sheet, when trying to multiply my vlookup cell with another cell value the Value error appears how can i resolve this thanks?

[georgianpetreanu]

Thank you for this. I have a bigger problem regarding the SUM function. If I use the formula to sum the values in a column, I get different values for the same inputs whenever I do it again. Checked online, and someone said to deactivate the automatic decimal choice from the Editing section of Options. Still doesn't work, though. Very strange is that in other columns, it doesn't happen. What could be the problem? Thanks!

[kirandeepchoudhry]

Thanks a lot, My problem will be very simple for Excelmaster like you Thanks

[tammeralittle]

You just saved me so much time. I have been googling for 20 minutes trying to figure this out and it was a simple as the Formula box being set to text. Ugh, I knew it was something simple, as I just purchased the computer and 365, but it was driving me crazy! Thank you so much for this. You just got yourself a new subscriber!!

[williecunningham]

Thanks for taking the time to post this. It really saved me a lot of messing around.

[va]

First troubleshooting tip solved it! I thought I was going mad! Working with huge amount of data, did not fancy adjusting it all manually. Thank you so much for your time to share this

[feliciaphillips]

First option worked - thank you so much!

[DannyDelRayMusicVideos]

Thank you, thank you. So simple. I watched 4 videos - none touched on the issue except you in the first 4 minutes. Keep up the good work.

[CelebrantsunshinecoastAu]

Thanks so much, the 5th one is a sneaky one, appreciate your efforts !

[kaps]

Dear, You teach me such a beautiful Technic to read all excel cell properly, God Bless You N keep posting more helpful vedios...

[Vlagstaf]

Thank you, your first advice helped me greatly, I have no idea why it turned to manual

[ambizzaresdiyotherstuff]

OMG the first reason is so obvious and I didn’t even think to check that! So helpful! Thanks😀

[NobleTenz]

Show formula one was my issue. Thanks a ton computergaga!🔥❤️likes and subbed

[ahmadmifzal]

Really really helpful and very precise explanation! Thank you!

[MasterMarillion]

Thank you very much! This was really heplful and simple. You've got my like & comment.

[Dedubya-]

Thanks so much, it was the first issue you mentioned. Wonderful :)

[bellvillebones]

awesome, thanks man! issues was literately the FIRST fix. not sure why excel change from automatic to manual...