How to Speed Up Calculating Threads in Excel

Microsoft Excel uses multiple calculating threads to process formulas and calculations faster. This feature, called multi-threaded calculation, allows Excel to use multiple CPU cores simultaneously to compute complex formulas, large datasets, and heavy workbooks more efficiently.

However, in some cases Excel calculations may still run slowly, especially when working with large spreadsheets, complex formulas, or poorly optimized calculation settings. If the calculating threads are not configured properly, Excel may not fully utilize your system’s CPU power.

If you want to speed up calculating threads in Excel, follow the methods below.

How to Speed Up Calculating Threads in Excel

The following steps can help improve calculation performance and make Excel process formulas faster.

1. Enable Multi-Threaded Calculation

Excel includes a setting that allows it to use multiple CPU cores.

1. Open Excel.
2. Click File in the top-left corner.
3. Select Options.
4. Go to the Advanced tab.
5. Scroll down to the Formulas section.
6. Ensure Enable multi-threaded calculation is checked.
7. Select Use all processors on this computer.

This allows Excel to use the maximum number of CPU cores for calculations.

2. Increase the Number of Calculation Threads

If Excel is not using all CPU cores, you can manually adjust the number of threads.

1. Open Excel Options.
2. Go to the Advanced tab.
3. Locate the Formulas section.
4. Select Manual number of calculation threads.
5. Set the number to match your CPU core count.

For example, if your processor has 8 cores, set the value to 8.

3. Change Workbook Calculation Mode

Excel may slow down when set to automatic calculation with complex workbooks.

1. Open Excel.
2. Go to the Formulas tab.
3. Click Calculation Options.
4. Choose Manual if your workbook is very large.
5. Press F9 when you want Excel to calculate formulas.

This prevents Excel from recalculating formulas after every change.

4. Optimize Complex Formulas

Large or inefficient formulas can slow down calculations.

Consider these improvements:

• Replace volatile functions such as NOW(), TODAY(), RAND() when possible.
• Avoid excessive array formulas.
• Use helper columns instead of extremely long formulas.
• Replace VLOOKUP with INDEX + MATCH or XLOOKUP when appropriate.

Optimizing formulas significantly improves calculation speed.

5. Reduce Conditional Formatting

Excessive conditional formatting can slow Excel calculations.

1. Select the worksheet.
2. Go to the Home tab.
3. Click Conditional Formatting.
4. Select Manage Rules.
5. Remove unnecessary formatting rules.

Reducing formatting rules can improve performance.

6. Disable Automatic Data Tables

Data tables can trigger repeated calculations.

1. Go to the Formulas tab.
2. Click Calculation Options.
3. Select Automatic Except for Data Tables.

This prevents Excel from recalculating large data tables automatically.

7. Close Unnecessary Applications

Excel calculations rely heavily on CPU resources.

To improve performance:

1. Press Ctrl + Shift + Esc to open Task Manager.
2. Close unnecessary applications consuming CPU or memory.

This frees system resources for Excel calculations.

8. Upgrade Hardware if Necessary

If you frequently work with large datasets, hardware upgrades can help.

Improving the following components can speed up Excel calculations:

• Faster CPU with more cores
• Additional RAM
• SSD storage instead of HDD

Excel benefits significantly from powerful processors and adequate memory.

Conclusion

Excel’s multi-threaded calculation feature allows the program to use multiple CPU cores to process formulas and large datasets more efficiently. However, improper settings or inefficient formulas can prevent Excel from fully utilizing available processing power.

By enabling multi-threaded calculations, optimizing formulas, adjusting calculation settings, and reducing unnecessary formatting, you can significantly speed up calculating threads in Excel and improve overall spreadsheet performance.