This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 11%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
I’m using excel to crunch massive amounts of data. I was previously using my 8th gen I7 laptop but this wasn’t able to run the spreadsheet any more, despite making lots of efficiencies with formula and macros (my macros are extremely basic).
I have now purchase a new desktop which has 18cores and 128gb of ram. Whilst the application crashes less, it still seems to broadly go at the same speed, or perhaps a little faster.
I’m using a 64bit version of excel on a 64bit version of windows OS. I have set the priority of the app in task manager to high (and also tried real-time). I have changed the options within excel to use all of the available cores - 18 physical, 36 in total. Excel states that there are 36 threads calculating when I executed the macros which seems to make sense.
When using the resource monitor in windows I can see that whilst all of the CPU’s are performing some excel tasks (all each below 2%) only one cpu seems to be dealing with excel - and it’s running at 100% pretty much all the time. If I set affinity to remove that cpu from the allocated resources for excel, it simply dumps all of that activity onto another individual cpu.
This is not at all what I was expecting, it should spread the threads across all of the CPU’s.
Help!
Hi @Steven Combes ,
How large is your Excel Workbook size?
I suggest you go to check if you enable the multi-threaded calculation feature in Excel, go to File- Options- Advanced- Enable multi-threaded calculation:
Refer to this suggestion first and check the result, any updates please let me know and I'm glad to help you.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
@Steven Combes
If you have a chance to be back, please check emizhang's suggestion.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 70%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Also have multi-threaded on with all cores available to excel 2021 as shown by the expert. Excel also shows all cores (8) running. However, only 1 core (2 threads) are being used in excel for any calculation. The only thing I can guess is something is containerizing excel but it doesn't make sense that excel is still showing 8 threads. Have been using Libre Calc more and more since Excel 365 came out; Excel 2021 is even worse, with 2013/pre-Excel 365 2016 being the best. Never noticed Excel 2016 issues with calculations. Can't test because Excel 2021 uninstalled 2016.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 6%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGU%3C/text%3E%3C/svg%3E)
I've also run into this issue - 12.5% of Memory is being used aka 1/8 cores are being used.
If anyone has this issue, they're already smart enough to enable multi-thread and I wish Microsoft would finally help with this issue and help us use 100% of our memory on Excel.
Like thousands of others, I'm near buying a new computer except I know Excel will only use 1/X of my new computer's cores and it will not solve anything. This has been an issue for more than a decade. Please help!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 26%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
I've the same problem in a Windows 2019 Server STD running on Vmvare ESXI 7.0.3. The only workaround that I've found is to run Excel in Windows 8 compatibility mode.