**Point:**Learn about the different ways to calculate in Excel and what to do if a formula isn't calculated when you edit the cell in question.

**SKILL level:**beginner

## watch the tutorial

## Download the Excel file

You can do this with the same workbook I use in the video. I am attaching below:

## Why doesn't my type count?

If you have ever come across a spreadsheet formula that is**not calculated automatically**As it should be, you know how frustrating it is.

This happened to my friend Brett. He told me he was working on the file and the file was not recalculating the formulas while entering the data. He realizes he needs to edit each cell and presses Enter to update the formula in the cell.

And this only happens on his home computer. His work computer is working normally. It drives him crazy and wastes a lot of time.

The most likely cause of this problem is the computer options pattern**, which is a basic setting every Excel user should know.**

To check which calculation mode Excel is in, go to**officially**tab and then click**calculation capabilities**This will bring up a menu with three options. this**Right now**There will be a check mark next to the mode. In the image below you can see this Excel**manual calculation method**.

When Excel is in**manual calculation**Drawing, formula on the worksheet**not calculated automatically**.You can quickly and easily solve the problem by changing the mode to**automatic**.In some cases you may want to use the manual calculation method, which I will explain in more detail below.

## Setting up calculations is confusing!

is**really important**Learn how computing patterns are changing. Technically, it is a**application level settings**.This means that the setting will apply to all workbooks you open on your computer.

As I mentioned in the video above, this is a question from my friend Brett. Excel on his home computer is in manual calculation mode and his file is not calculated. When he opens the same files on his work computer, they calculate just fine because Excel on that computer is in automatic mode.

However, they exist**There is a basic nuance here**The .work workbook (Excel file) also stores the last saved calculation settings and can change/undo settings at the application level.

This should only happen inside**The first file was opened during an Excel session**.

For example, if you switch Excel to manual calculation mode before saving and closing the file, the setting will be saved with the workbook. If you then open the workbook as the first workbook in an Excel session, the calculation mode will change to manual.

Any subsequent workbooks you open during this session will also be in manual calculation mode. If these files are saved and closed, the manual calculation function will also be saved with the files.

this**The confusing part of this behavior**Yes, it only happens for the first file you open in a session. After you completely close the Excel application and then reopen it, Excel will return to automatic calculation mode if you first open a new blank file or any file that was in automatic calculation mode.

**Therefore, the calculation method of the first file you open in an Excel session determines the calculation method of all files opened in that session. If you change the calculation method in one file, all open files will be changed.**

**notes:**I made a mistake in the video when I said that the calculation settings do not move with the workbook, I will update the video.

## 3 calculation options

There are three calculation options in Excel.

**Automatic calculation**Indicates that when a cell value or formula changes, Excel will recalculate all related formulas.

**manual calculation**means that Excel will only recalculate if you force a recalculation. This can be done by pressing a button or a keyboard shortcut. You can also recalculate individual cells by editing the cell and pressing Enter.

**Automatic, except for data sheets**means that Excel will automatically recalculate all cells except those used in the data table. This is**Yes**reference normal**Excel Tablica**You will probably work a lot with it. This is a situational analysis tool that not many people use. Are you**data**card, u**Hypothetical scenario**button. Therefore, if you are not using these datasheets, it is unlikely that you will intentionally change the setting in this option.

except in**data**card, you can also use**Excel options**Menu. to go**document**, Afterward**choices**, Afterward**officially**See the same setting options at**Excel Options window**.

lobe, below**handbook**option, you will see a check box**Recalculate the workbook before saving**,This is the default setting. This is good because you want the data to be calculated correctly before you save the file and share it with colleagues.

## Why use the manual calculation method?

If you are wondering why someone would want to change the calculation**automatic**reach**handbook**, for one key reason. when you use it**Large files with slow calculations**, the constant recalculation every time a change is made can sometimes slow down your system. well people sometimes**switch to manual mode**When it comes to changes in data-heavy sheets, then**turn back**.

When in manual calculation mode, you can**force calculation**use anytime**do the math now**active button**officially**Let me underline.

keyboard shortcuts**do the math now**And`F9`, he reckons**the entire workbook**.if you just want to count**current sheet**, you can select the following button:**calculator**.The keyboard shortcut for this option is`TRANSPORT`+`F9`.

Here is a list of all recalculated keyboard shortcuts:

shortest way | describe |

F9 | Recalculates formulas that have changed since the last calculation, as well as formulas that depend on them, in all open workbooks. If the workbook is set to auto-recalculate, you do not need to press F9 to recalculate. |

Shift+F9 | Recalculates formulas that have changed since the last calculation, as well as formulas that depend on them, in the active worksheet. |

Ctrl+Alt+F9 | Recalculates all formulas in all open workbooks, regardless of whether they have changed since the last recalculation. |

Ctrl+Shift+Alt+F9 | Checks for related formulas and then recalculates all formulas in all open workbooks, regardless of whether they have changed since the last recalculation. |

## The macro has been switched to manual calculation mode

If you find that your workbook is not automatically calculated, but you did not intentionally change the mode, another possible reason for the change is**because of the macro**.

now i want to say**Not all macros cause the problem**.This is a specific line of code that a programmer can use to make a macro run faster.

The next line of VBA code**Tell Excel to switch to manual calculation mode**.

Application.Calculation = xlCalculationManual

Macro writers sometimes add this line at the beginning so that Excel doesn't try to calculate while the macro is running. The setting must then be changed again at the end of the macro using the following line.

Application.Calculation = xlCalculationAutomatic

This technique works well for large workbooks where calculations are slow.

However, a problem arises**when the macro does not complete**— It may be due to a bug, program error, or unexpected system problem. The macro changes the setting to "Manual" and does not change it again.

As I mentioned in the video, this is exactly what happened to my friend Brett without his knowledge. He is in manual calculation mode and doesn't know why or how to get Excel to recalculate.

So if you use this technique in your macros, I encourage you to consider ways to mitigate this problem. and**Notify your users that Excel may be in manual calculation mode.**

I also recommend not changing the Calculate property in code unless you absolutely have to. This will help prevent frustration and mistakes from your macro users.

## in conclusion

I hope this information is helpful, especially if you are currently experiencing this issue. if you have them**question or comment**For calculation methods, seeComment.