Reply to thread

Message

<blockquote data-quote="Tony_P" data-source="post: 1932015" data-attributes="member: 418636">I’ve been very happily using my 2020 Mac Mini for work and at home for the last three years, but had to work in a big enough Excel file this week that it was struggling, badly.It was a 36Mb data file, with 800,000 rows and about twenty columns, and despite trying to be as efficient as I could at losing the town and columns that I didn’t immediately need, it still ran out of memory quite quickly, and having to re-start with different rows for each bit of work was a pain. As soon as I had a calculation on every row it slowed to a crawl, and any second one that referenced multiple rows pushed it over the edge.I’ve only 8Gb RAM, which is very likely the problem, and a faster processor wouldn’t hurt either, so am going to buy a new M2 Pro mini.The question is, do I go for 16Gb or 32Gb of Ram? Is the limitation on large Excel sheets purely the RAM, or is the limitation based on how many calculations it’s trying to do while also working out which order to do them in?</blockquote>

[QUOTE="Tony_P, post: 1932015, member: 418636"] I’ve been very happily using my 2020 Mac Mini for work and at home for the last three years, but had to work in a big enough Excel file this week that it was struggling, badly. It was a 36Mb data file, with 800,000 rows and about twenty columns, and despite trying to be as efficient as I could at losing the town and columns that I didn’t immediately need, it still ran out of memory quite quickly, and having to re-start with different rows for each bit of work was a pain. As soon as I had a calculation on every row it slowed to a crawl, and any second one that referenced multiple rows pushed it over the edge. I’ve only 8Gb RAM, which is very likely the problem, and a faster processor wouldn’t hurt either, so am going to buy a new M2 Pro mini. The question is, do I go for 16Gb or 32Gb of Ram? Is the limitation on large Excel sheets purely the RAM, or is the limitation based on how many calculations it’s trying to do while also working out which order to do them in? [/QUOTE]

Verification

Name this item 🌈