I feel like I'm going to fall for the new m1, has anyone tested pivot tables and stressed excel to its limits (large excel files ,more than 100 000 rows and plenty of columns, functions across sheets...) on a macbook m1? what were your impressions? how much RAM is better to choose for this use (8 or 16gb?). Thanks in advance
Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
M1 with pivot table and intensive Excel usage?
- Thread starter Jeanora
- Start date
- Sort by reaction score
I'd argue that anyone (include the UK government*) using MS Excel for 100K rows is completely using the wrong piece of software for their needs.
*This error by the UK gov likely resulted in 1500 extra COVID-19 deaths.
*This error by the UK gov likely resulted in 1500 extra COVID-19 deaths.
I use the 16.34 versions of office with absolutely no issues.
No reason to use beta-software unless you can tolerate loss of their contents.
Thanks for your reply, sometimes I like excel pivot tables for its ability to quickly explore large datasets (a kind of first look), don't worry, nothing that could have a critical impact on health or business issues which need more reliable tools...). My point is that I just want to know if the M1 already bring an improvement in speed compared to excel in the intel-mac (even for a non yet optimized software)
I sometimes open 1000-page Word docs (large grant submissions) and large Excel files with raw data and it is significantly faster (the M1MBA) than any other machine machine I have in the lab, i.e. any kind of workstation. It's instantaneous.
I have done some testing with the Beta version of Excel that is native for Apple Silicon. It is stable, have not seen a problem yet. I did some comparative testing with my Intel Late 2016 iMac, that has 4 x 4GHz cores. The calculation speed is not significantly faster with the M1. I have a monster spreadsheet that I used for some financial modelling. It has over 4 Million complex formula on just one tab. Inserting new calculation blocks causes a delay while Excel updates the spreadsheet and formula. I created a VBA Macro that loops the process a number of times. On the iMac it took 3 Mins and 4 seconds to complete, on the M1 MacBook Air it took 2 mins and 49 seconds.
That's why I said Excel is mostly single threaded. I know about that, but there is a lot of instances where it still only act as single threaded.
Thanks , i saw the video but I wanted to complete by more specific usage, acidfast7 and james
_c gave me some interesting additional information. Now I try to choose between 8Gb or 16bg (yes I like to open many things : big pdf files, lot of open browser tabs, programs...)
I don't have any large files to try , point me to one and I will slice and dice it all day long to see how it works.
(I am mostly a hardcore excel on windows on a dramatically crappy set up guy - I will bring my work machines to the ground. I don't use it on Mac because I don't do it at home, and I don't like the subtle differences. But I have it and I can try it given a file)
I am the guy who when I was five, my dad told me "lotus 123 is the only program you need, see you can type in it who needs a word processor" - and 40 years later I am like "who needs a database, I am straight up doing this wrong just because I can
"
That said - do you get it from the MS site or the App Store for the M1 compatible?
(I think I use the Mac store versions now on my other Macs?)
I have a base model M1 Mac mini.
I can also compare to my i7 64gb Mac mini.
(I am mostly a hardcore excel on windows on a dramatically crappy set up guy - I will bring my work machines to the ground. I don't use it on Mac because I don't do it at home, and I don't like the subtle differences. But I have it and I can try it given a file)
I am the guy who when I was five, my dad told me "lotus 123 is the only program you need, see you can type in it who needs a word processor" - and 40 years later I am like "who needs a database, I am straight up doing this wrong just because I can
"That said - do you get it from the MS site or the App Store for the M1 compatible?
(I think I use the Mac store versions now on my other Macs?)
I have a base model M1 Mac mini.
I can also compare to my i7 64gb Mac mini.