Excel - best hardware configuration for best performance (multi core support?)
Posted on 2014-12-21
I have a user with whom we are spec’ing up a Mac Pro for (which will be running Windows 8 via Boot Camp).
We are debating the number of cores to get and how much memory to put into the Mac Pro. The user will go up to the fully loaded spec if necessary (and this comes in about £10k with 96GB of memory)
But we want to know if it’s worth it.
The user works in finance and have Bloomberg running, but a particular thing he does also use is Excel with various third party plug in’s he’s purchased as well as coding he does himself.
Research so far has learnt that if he uses VBA that can only make use of one core tops, but I’m wondering if it’s possible if some of his third party plugins might do (There are numerous ones)
I’m not sure at present if he will use the 32 bit or 64 bit edition of Excel. I assume the 32 bit version of Office can only address 4GB of memory (it will be on a 64 bit OS).
So if this is his use, is it a waste of time buying say 64GB instead of 32GB (Adds another £640 / $1100).
Also is it worth going for lots of additional cores which again can make a jump in price.
The user is prepared to pay for the best performance, but of course does not want to unnecessarily spend, if it’s not actually going to make a difference to performance.
He will be running three displays of the Mac Pro also.