3 Reasons Why Excel Formulas Won’t Calculate + How to Fix – Excel Tutorial

Excel formulas not calculating??? Take a look at 3 things that can cause your Excel formulas to stop working and how you can fix the formulas.

When Excel formulas don't calculate, it's typically due to numbers and / or formulas accidentally formatted as text or a change in the settings of the workbook.

In this Excel tutorial, we'll go over issues with text formatting and with formula and calculation settings that can make your formulas not work. All are surprisingly easy to fix!

*FYI:

Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊

Thanks!

*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!

#YAcostaTutorials

[binoysandeep]

YOU ARE AMAZING! SHORT AND TO THE POINT. I SPENT 2 HOURS ON A DATA SHEET AND WAS STUCK ON A PROBLEM. YOU HAVE NO IDEA HOW MUCH YOU'VE HELPED ME

[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!

[girl]

Quickly covers problem areas with clear instructions on how to fix your Excel problem. Doesn't draw out explanations or long beginning opening remarks. It was perfect.

[jamesweir]

Replacing = with = has saved my life. Thank you.

2.30 in the morning with so much things to update and this has allowed me to sleep instead of working through the

Been looking for this for so long (always give googling this a go and can never find a solution that isn't click into every formula)

[USAFdude]

13 Jan 24: Before I found your video, I must've watched 10 other ones to figure out how to fix my number columns that wouldn't sum. When you suggested going to Data and Text to Columns, that was the trick I needed to fix my problem. Thanks for being awesome and helping me overcome massive frustration!

[stevensaguilar]

Excel is amazingly hard with only basic understanding and this video alone expanded my knowledge by so much! I was spending hours trying to figure out my excel sheet's issues to no end until I decided to google it out and I found you through it all. You're not the hero I asked for but definitely the one I needed!

[kenodan]

Thank you very much!!! I am a self-taught spreadsheet user over the age of 60 and your information helped me understand what to look for, and how to fix it. You are amazing!

[subhashdhoke]

Thank you mam. I can solve my problem for which i was suffering for last three to four days. Such video is not available on you tube. Really thank you....

[Doggy]

Omg! This really helped me. I have to admit I thought it was a waste of time as soon as I began watching and you answered my concern on point one. Ty!

[trailus-co]

I been searching for ages with no joy someone on internet said its macro settings had do that nothing then your last option show formulas an hey presto i got a working spreadsheet Thank You sooo much. Like most things soo simple when u know how

[tejassoni]

Thank You for posting this Video with the resolution of the formulas not working.
It was the first time faced such query in excel but You tutorial helped me out. Thanks once again👍

[robinowen]

helped me to thanks, I think it because I made my excel sheet on my iPhone it did not work properly but looking at your video and editing the formula on my pc it works again for me. a big thanks from me

[Al-matharTingkahan-nvls]

Thumbs up to you thanks a lot I've been working on this unsuccessfully again and again until i found your video.. Again thanks a lot

[watchahiran]

Oh God! I've been trying to solve this problem for a long time, Thank U so much

[chrysantemoure]

I really like it, it saved my life. I was going crazy with this formula.. Great i fixed it. Thanks

[joannaandrademk]

Thank you! OMG! I have been having this issue for a some time now. With your help, it has been corrected. Greatly appreciated

[ermiasamare]

I want to thank you very very much.... It is very helpful and my problem has now been solved!!

[kevancamp]

This video is brilliant! Short, to the point, and solved my problems 100%

[gejovarghese]

the trick of replacing = with = was very very useful, Thanks.

[daniellew]

OMG this helped sooo much! I have been trying to figure this out for the last 4 hours.