How to disable multi-threaded calculation in Microsoft Office Excel

Microsoft Office Excel by default uses all your computer processors by default. This is of course very handy because the calculations are done faster using this technology, however, if you’re doing other tasks on your system this could lead to other program’s not responding.

In this tutorial we will show you how to disable multi-threaded calculation in Microsoft Office Excel. Let’s get started

How to disable multi-threaded calculation in Office Excel

1. Begin by starting Microsoft Office Excel, once it’s started click on File and then Options

2. Then click on Advanced and scroll down till you find Formulas

By removing the check from “Enable multi-threaded calculation” you can disable this feature. However you can also choose to set it to manual and choose how many processor core’s might be used for calculation. You can choose to have 1 or 2 do the calculation, however it might be smart to use at least 50% of your core’s to ensure everything keeps working smoothly.

You can always choose to turn back multi-threaded calculations by simply following the steps above and enabling the check again.

We hope this article has helped you on how to turn off or change the amount of calculation threads that Microsoft Office Excel is allowed to use. If you have any questions, than feel free to reply and we will try to help you.

About the Author

2014, 2015, 2016, 2017 and 2018 Microsoft Most Valuable Professional Windows
Yuri specializes in troubleshooting (crash analysis and devices), system resource utilisation and system performance. He is also very interested in Customer Security. Yuri can be found as Windows Community Moderator and Wiki Author on Microsoft Answers and is active on different communities all across the web.

Leave a Reply

Your email address will not be published. Required fields are marked *