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]
I appreciate the weekly improvements, but need to note that FIND (and Replace) only work once or twice without closing and reopening Excel.
Please work on that so I don't have to keep closing and opening everything.
Currently I see the calculating 8 cores in my sheet with a lot of vlookup formula's. Since the latest FAST release I notice much slower calculation then before the update to use utilize multiple cores. Do others have the same experience?
Using an i7 2.2GHz 16GB MacBook Pro...
It is absolutely ridiculous that MS would sell such a piece of ****. MS Office for MAC is JUNK and is lacking in EVERY APPLICATION!!! Thank You MS for not caring.
gav b commented
So its been a while since I bothered to do an update (having all but given up with this insane situation)... now on the latest 171219.
Unfortunately, no noticeable improvement - still complete rubbish calc speed on formula heavy spreadsheets - basically unusable.
I am not usually a conspiracy theorist - but, in this case? Perhaps the marketing folk at MS should rename this product Excel 'Not Really' for Mac?
Aah 667th comment already, I missed to put in the devils comment.
Ok, so what changed since multi core processing was enabled? We no longer see the 'Calculating 2% using 1 CPU at the bottom task bar of Excel. Instead the who CPU thing is out. So we are hoping there are more than one cores are play since the calculations are slightly better than before.
Navigating in the spreadsheet doesn't always refresh the view, if I use command-up to get to the top of a column, i have to then scroll a little or use the arrows to get the screen to refresh the view, even though the right data field is selected. same with command-right or -left when it goes off screen.
VLOOKUP for 165,000 rows didn't seem to calculate much faster with multi-threading on my early 2015 MacBook Air with 1.6 GHz Intel Core i5
Keeps getting better, but I've noticed the commands to add to the quick access toolbar are not correct.
The "Paste values and number Formatting" pastes the values and formats of the original cell
The "Paste Values and Source Formatting" pastes the original formula (not the values).
I can't find a way to do what, through normal menu, is "edit/paste special/values", which just brings the value and keeps the format of the destination.
Having a lot of issues with workbooks from a shared drive. Resulting in a lot of unexpected terminations of excel. Also a lot of times there are cells displayed blank that do contain values of any sort. Clicking on the cell will show the contents in the formula bar.
Two more comments so far.
1. This latest version does not always refresh the screen. In one example I can clear contents of a column that is used by others for vlookup, and the columns continue with there old values until I click another worksheet in the workbook and then click back.
2. Also it often thinks I'm trying to save an .xlsx file as an .xls, and tells me I will lose information, etc. with another long error message after. It seems to work if I save it to replace a file I already have as .xlsx.
These files originate from a Windows 12 server, in an .xls format, but are normally changed to .xlsx on Windows computers before being emailed to me.
I installed version 16.8 (171126) and calc is significantly faster, although I noticed that it is slower to open the file.
Dezső Mitók commented
What is the estimated release date for this 16.8.171111 version? I cant wait to see it but my office update does not allow me to opt in....enterprise controls I guess.
By the way it is not true that current xls for mac is using 1 processors. It is using only one thread of the one processor. When calculating it makes 1/8 load on my i7 macbook pro. Wasting.
Brou Gautier commented
Yikes! to deleted all personal macros....
One more discovery of this latest version. It deleted all macros in my personal macro workbook.
Hi everyone - Just to keep you all informed, we discovered an issue with add-ins causing Excel to start with Multi-threaded calculation disabled. If you have the Analysis Toolpack or Solver enabled, this would cause Excel to start with MTR disabled. Other add-ins may cause the same issue. We plan to have this fixed in an upcoming release.
I just installed it and first thing I did was load a spreadsheet that I filter many times a day, with a constant 8 second filter of the 9000 lines. The filter improved to 6 seconds. Certainly not as much as I would hope. The number of processors no longer shows, just the percent.
Editing one cell on one of the other sheets in the workbook reduces the calculation speed from 5 seconds to 2.4. Again, a good start, but I would like more.
My 10 second macro is down to 4.85 seconds.
Hopefully more to come.
A side surprise is that when opening large sheets I no longer get a big white space that required me to scroll in both directions to fill.
i saved a windows xlsx file with multithreading enabled but it did not calculate in multithread mode on the mac (having 12c/24t and 96 GB RAM which are way enough ressources to do the job).
Upgraded old slow windows 7 laptop to a new MacBook Pro as excel was running slow on a large spreadsheet, only to find out the same spreadsheet is now 3x slower on MacBook...major step backwards.
I am having the same rendering problems pointed by Marcin. Looks like we are back to previous unstable versions. It also crashes often.
I noticed a slight difference in speed, especially during many search functions (ver. 171114).
But I have different problems with graphics and display. Moving cursor when I compose formula or making selection is weird, border around selected cell appears few ms after. Some cells doesn't renders, they are empty, until I scroll sheet a little.
Does anyone have similar problems?
Jose G Machado commented
I was able to enable the cores of my Mac, There have been improved speed improvements in Excel, but the calculations, is that they are still very slow!