Will Excel for Mac 2016 utilize multiple cores on Mac?
Excel for Mac now has multi-threaded calculation, as of the release of version 16.9 on 18-Jan-2018. To update, go to Help > Check for updates. Thanks for all of your comments and support for this feature.
As mentioned in earlier comments, if you encounter any issues, please send the details to us by clicking the smiley-face button in the top right corner of the Excel window.
Thanks – Steve K [MS Excel]
Mark Russell commented
Please fix Excel for Mac to utilize multiple processors!
Jason Bunston commented
I have a very large, data-driven excel worksheet with visual dashboards.
I deleted a column of heavily reference data, hit save. One core maxed out for a split second, then all four Cores lit up. The recalculation was very, VERY much faster.
E Hurtley commented
Tried with the latest Fast update - iMac (i5 2.6 GHz, 24 GB RAM) and it still only seems to be using 1 CPU for calculations. When starting Excel up, it uses more than one CPU, but for actual worksheet calculations, Activity Monitor still only shows 100% (meaning "all of one CPU") usage.
Hopefully a later build will improve that.
This is on a 1.3 GB Excel file, with many tabs, where each tab has independent calculations - so there shouldn't be any massive dependencies that should restrict it to one CPU. It should be able to do each tab separately on separate CPUs. When opening on my Windows machine, it uses all CPU cores (but, sadly, my Windows machine doesn't have enough RAM to work with it well. So my choices have been "not enough RAM to hold the file, causing massive disk thrash" vs. "enough RAM, but won't use multiple CPU cores, causing massive delays when recalculating.")
Stuart Thom commented
It's nice to see some light at the end of the tunnel. I downloaded Fast Ring release and ran several large sheets on my Macbook Pro (Mid 2015, 2.5GHz i7, 16GB) and they were quite a lot faster. It was a bit buggy around other areas, and Autosave is turned off, so have reverted to standard for day to day, but good to see the improvements coming our way. Fingers crossed!
Hello. I am using a 2017 MacBook Pro (3.5GHz i7 with 16GB Ram), I normally use large files on Excel (>50 MB) at my work pc with lots of rows, lookups, array formulas etc that were impossible to use on a Mac, whereas on my pc which on paper is slower, it works pretty smoothly. Even after this upgrade, these files are still impossible to run on my Mac (it actually crashed a couple of times), even though I saw the message "4 processors" when it was calculating. Hopefully since it is still in the testing build, the regular build will be more stable and faster.
Interesting, I am also using a Late 2016 MBP, but just an i5. Have you tried to restart. I didn't observe improvements on the first set of sheets, but later did.
gav b commented
I have done the upgrade to 171101 (fast update). I had high-hopes that this nonsesne would finally come to an end.
On my late 2016 2.7GHz Core i7 MacBook Pro, there is zero improvement. Interestingly, the notificatiion beside the 'Calculating %' at the footer of the Sheet stating a single core was utilised has disappeared. Still completely unusable for heavier spreadsheets.
Oh, and I have had several crashes. So, its got even worse. Genius!
Interesting that some people have seen an improvement - perhaps processor specific? At least some progress...
Some clarity from MS would be kind of nice!
I did the upgrade yesterday and ran calcs on multiple sheets at the same time this AM and observed Excel showing "Calculating (8 Processor(s))"
In Activity Monitor Excel's CPU is at 200%
MS is on the way to a fix, Thank You
Dennis Lau commented
At least we know for sure MS is working on this
But at least its A LOT faster .. life in the Fast Ring
Glen B commented
I agree it's flakey. I wish I had not installed it.
It's definitely flakey. The large model I was testing yesterday on my iMac is now not showing multiple processors with recalc but another one is.
Excel will say 4 Processors. You can also use Activity Monitor. You will have up to 400% utilization (100% * 4 Processors).
Nothing mentioned in the release notes - https://support.office.com/en-us/article/Excel-2016-for-Mac-–-Release-notes-for-Insider-Fast-builds-2425ec86-7c37-4d37-a276-225d4d7e1e17?ui=en-US&rs=en-US&ad=US
I was able to confirm, all 4 processors are being utilized on my MacBook Pro! I used a large dataset with multiple vlookups and it finally displayed calculating: 4 processors!!!
What would have taken easily 20 min to calculate took about 1 min.
Be aware, I've had several crashes already...
Glen B commented
Wajid, use Microsoft Auto-update to opt in to Fast Updates.
How did you guys installed 171101? Mine is Version 15.39 (171010) and does not show any available update. any help pls?
Is there a way to install the regular build and a fast edition build on the same Mac so I can compare the two versions?
Some input from a office admin would be great.
tested it with the file included in this article: https://www.get-digital-help.com/2014/07/04/optimize-pick-path-in-a-warehouse/
From the current stable version to the insiders fast edition an difference of 30 seconds on the calculation on the "path" sheet. Indeed never saw CPU usage go over 100 in activity monitor but still a bit faster ( MacBook Pro 2017 3,1GHZ I7) . But then again not as fast as my 4 year old surface pro 3 dual core.
Maby anyone could test the same file and post his results?
So I have the update, MUCH faster. I haven't decided if it is multi core enabled. I never see the CPU usage go over 100 in the activity monitor. So it's still using only 1 core? Maybe it's doing it so fast I cannot check it...but it is totally faster now.