Office Office 2016 Office 2019

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.

Leave a Reply

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