How to Stop Calculating Threads in Excel (4 Handy Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

How to Stop Calculating Threads in Excel


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.

How to Stop Calculating Threads in Excel

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.

How to Stop Calculating Threads in Excel

  • Secondly, select Options.

An Excel Options dialog box will appear.

  • Thirdly, we will select Formulas >> we will scroll down until we find Calculation options.
  • Afterward, from Calculation Options >> select Manual option.
  • Next, click OK.

How to Stop Calculating Threads in Excel

  • 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. 

How to Stop Calculating Threads in Excel


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.

How to Stop Calculating Threads in Excel

  • 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.

How to Stop Calculating Threads in Excel

An Excel Options dialog box will appear.

  • Next, select Advanced >> scroll 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.

How to Stop Calculating Threads in Excel

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 drag down 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.

How to Stop Calculating Threads in Excel

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.

How to Stop Calculating Threads in Excel

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 drag 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.

How to Stop Calculating Threads in Excel


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


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo