If you want to stop calculating threads in Excel, this article is for you. Here, we will demonstrate to you 4 easy and effective methods to do the task effortlessly.

## How to Stop Calculating Threads in Excel: 4 Methods

The following table has Product, Basic Price, VAT, and Total Cost columns. Using this table, we will show you how to stop calculating threads in Excel. Here, we used Excel 365. You can use any available Excel version.

## Why Do We Need to Stop Calculating Threads?

Calculation Threads are when Excel can recognize segments of the calculation cycle, and recalculate simultaneously on different threads. These calculation threads run side by side, and therefore, create a problem. Along with that, in many situations, we do not need recalculation. In these cases, stopping calculating threads is necessary.

Let me explain to you how you can understand whether the calculation thread is open or off.

**Steps:**

- First, type the following formula in cell
**E5**.

`=SUM(C5,D5)`

**Formula Breakdown**

**SUM(C5,D5) â†’**adds cell**C5**with cell**D5**.**SUM(10000,100)**â†’ becomes**Output: $10100****Explanation:**Here,**$10100**is the**Total Cost**of a particular**Product**.

- After that, we press
**ENTER**. Then, you can see the result in cell**E5**. - Next, we
*drag down*the formula with the**Fill Handle**tool.

Here, you can see the formula is now automatically calculated in other cells of the** Total Cost **column.

Next, we will change the value of cell **C6**, and we will notice that the **Total Cost **in cell **E6** will change.

- Further, we set the cell
**C6**value as**$8000**, and we can see that cell**E6**changes automatically.

This is because of calculation threads. In many cases, we do not want calculation threads and **AutoFill **formulas in cells. To stop calculating threads in Excel, we will go through the following 4 methods.

### 1. Using Formulas from Excel Options to Stop Calculating Threads in Excel

In this method, we will go to the** Formulas** from **Excel Options** and select the **Manual** Calculation option to stop calculating threads in Excel.

**Steps:**

- Firstly, go to the
**File**tab.

- Secondly, select
**Options**.

An **Excel Options** dialog box will appear.

- Thirdly, we will select
**Formulas**>> we will s*croll down*until we find**Calculation options**. - Afterward, from
**Calculation Options**>> select**Manual**option. - Next, click
**OK**.

- At this time, we will go to our worksheet.

Here, we will change the value of cells** C6** and **C8** respectively. Along with that, we will notice whether there occurs a change in the Total Cost columnâ€™s cells **E6** and **E8**.

- Later, we changed the value of cells
**C6**and**C8**to**$7000**and**$8500**. However, we can specify that no change has occurred in the**Total Cost**columnâ€™s cells**E6**and**E8**.

In addition to this, we will check whether the **AutoFill **feature works or not.

Here, we can see the formula of cell **E5** in the **Formula Bar**.

- After that, we will
*drag down*the formula with the**Fill Handle**tool.

Finally, we can see that not the formula of cell **E5** but rather the value of cell **E5 **has been copied in the other cells.

As a result, the calculating threads in Excel have stopped.**Â **

### 2. Use of Calculation Options Feature to Stop Calculating Threads in Excel

Here, we will use the Calculation Options Feature from the Formula tab to select the Manual option, so that, we can stop calculating threads in Excel.

**Steps:**

- In the beginning, we will go to the
**Formulas**tab >> from**Calculation Options**>> select**Manual**.

Now, we will change the value of cells** C6** and **C8** respectively. Along with that, we will notice whether there occurs a change in the **Total Cost** columnâ€™s cells **E6** and **E8**.

- At this point, we changed the value of cells
**C6**and**C8**to**$85000**and**$7000**. However, we can notify you that no change has occurred in the**Total Cost**columnâ€™s cells**E6**and**E8**.

Along with that, we will check whether the **AutoFill** feature works or not.

Here, we can see the formula of cell **E5** in the **Formula Bar**.

- Then, we will
*drag down*the formula with the**Fill Handle**tool.

Next, we can see that not the formula of cell **E5** but rather the value of cell **E5 **has been copied in the other cells.

Therefore, the calculating threads in Excel have stopped.

### 3. Use of Advanced Feature from Excel Options

In this method, we will use the **Advanced **Excel option to select the** Manual** Calculation option to stop calculating threads in Excel.

**Steps:**

- First, go to the
**File**tab.

- Furthermore, select
**Options**.

An **Excel Options** dialog box will appear.

- Next, select
**Advanced**>>*s**croll down*until**Formulas**come along. - After that, mark
**Enable multi-threaded calculation**box >> select**Manual**option >> click**OK**.

- At this point, we will go to our worksheet.

Now, we will change the value of cells** C6** and **C9** respectively. Also, we will notice whether there occurs a change in the **Total Cost** columnâ€™s cells **E6** and **E9**.

- Next, we changed the value of cells
**C6**and**C8**to**$10500**and**$8000**. However, we can specify that no change has occurred in the**Total Cost**columnâ€™s cells**E6**and**E8**.

Along with this, we will check whether the **AutoFill** feature works or not.

Here, we can see the formula of cell **E5** in the **Formula Bar**.

- After that, we will
*d*rag*d**own*the formula with the**Fill Handle**tool.

As a result, we can see that not the formula of cell **E5** but rather the value of cell **E5 **has been copied in the other cells.

Hence, the calculating threads in Excel have stopped.

**Read More:** How to Stop Calculating 8 Threads in Excel

### 4. Using VBA to Stop Calculating Threads in Excel

In this method, we will use** VBA code** to stop calculating threads in Excel. This is a quick and handy method.

**Steps:**

- First of all, we will go to the
**Developer**tab >> select**Visual Basic**to bring out the**VBA**editor window.

You can also press the keyboard shortcut **ALT+F11** to bring out the** VBA **editor window.

Next, a **VBA **editor window will appear.

- After that, from the
**Insert**tab >> select**Module**.

- At this point, we will type the following code in the
**Module**.

```
Sub Stop_Calculating_Threads()
Application.Calculation = XlCalculation.xlCalculationManual
End Sub
```

**Code Breakdown**

- Weâ€™ve created
**Sub procedure**as*Stop_Calculating_Threads()* - Then changed the
**Calculation**mode and set it to**XlCalculation.xlCalculationManual.** - So, it will change the
**Calculation Options**to**Manual**.

- Afterward, press the
**Run**button marked with a**Red**color box to**run**the code.

In contrast, you can press the **F5** key to run the code.

- Next, we will go to our worksheet.

Then, we will change the value of cells** C6** and **C8** respectively. Also, we will notice whether there occurs a change in the **Total Cost** columnâ€™s cells **E6** and **E8**.

- After that, we changed the value of cells
**C6**and**C8**to**$7000**and**$8500**, but we can see that no change has occurred in the**Total Cost**columnâ€™s cells**E6**and**E8**.

At this point, we will check whether the **AutoFill** feature works or not.

Here, we can see the formula of cell **E5** in the **Formula Bar**.

- Moreover, we will
*d**rag down*the formula with the**Fill Handle**tool.

Hence, we can see that not the formula of cell **E5** but rather the value of cell **E5 **has been copied in the other cells.

Finally, the calculating threads in Excel have stopped.

**Read More: **How to Make VBA Code Run Faster

## Practice Section

You can download the above Excel file to practice the explained methods.

**Download Practice Workbook**

## Conclusion

Here, we tried to show you 4 methods to stop calculating threads in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section below.

## Related Articles

- How to Make Excel Open Faster
- How to Improve Excel Performance with Large Files
- How to Make Excel Faster on Windows 10
- How to Make Excel Run Faster with Lots of Data

- How to Open Large Excel Files Without Crashing
- How to Make Excel Calculate Faster
- How to Speed up Excel Calculating 4 Processors

**<< Go Back to How to Speed Up Excel | Excel Files | Learn Excel**