14 replies to this topic

[daverty]

Hello,
I wonder if you can recommend the best pc setup that would maximize EXCEL 2010 performance….I understand this version of excel can utilize up to 1024 threads – meaning processors – so I guess the more CPUS the better…or less CPUs with higher speed? Than more with slower speed as the Xeon e5 series for example?

I wonder what your experience has been with multi-core calculations in this version of Excel? Or even in Excel 2013? There is so little information on the interment on the excel performance benchmarks. I hope you can share some of your experience in multi-threaded Excel calculations on your own computer?
Thanks!

[Onion]

What do you plan on doing on Excel? What are your current specs?

[ComputerEd]

I have personally never seen an Excel spreadsheet that has pushed a CPU very hard. Now I am not saying they do not exist but I would find it hard to believe you would need to have anything past an i5 for even the biggest spreadsheets. I have seen low RAM space however effect them a lot. I would say if you got a decent i5 or FX chip (6 core or above) and put in 16 Gig with an SSD for the apps and spreadsheet storage, you should not see any kind of slow down. Again however this is a gut reaction since I have never seen a truly massive spreadsheet in action.

If however you have such a spreadsheet and want to know how the performance is effect by the CPU thread count, and processor speed, send it to me and I will be happy to run some tests for you.

[d6bmg]

Generallt a descent I5 would be enough. To get better speed, SSD is compulsory.

[Waco]

Generallt a descent I5 would be enough. To get better speed, SSD is compulsory.

Why do you think an SSD would help Excel calculations?

[d6bmg]

Why do you think an SSD would help Excel calculations?

My bad. I mean to say that having an SSD is helpful as it will reduce saving time, load time (which should come into play while working with long excel documents).

[Waco]

More threads == faster.

Just take a look at this: http://www.anandtech...duct/288?vs=287

A 2500K is eclipsed by the 2600K in the Excel benchmark - and the old real difference between the two CPUs is hyperthreading. More real cores would be even more beneficial. Granted, this is Excel 2007, but from what I've seen 2010 is far more threaded.

[SpeedCrazy]

I've messed with some pretty huge spreadsheets but the only things my i7 920 and 6gbs or ram have not been able to handle snappily was when i made 3 pages of inserted checkboxes(don't ask) that took about 2 mins to load every change. But other than that so long as a good amount of my ram is free i have no problems.

[d6bmg]

^^ Thanks for the feedback gathered from your own experience. It helps everyone, a lot.

[d6bmg]

double post.. delete it please.

Edited by d6bmg, 04 December 2012 - 07:30 AM.

[daverty]

thanks)) I wonder with i7 3930k can comment on using 12 threads in excel 2010?

[Onion]

thanks)) I wonder with i7 3930k can comment on using 12 threads in excel 2010?

I have an i7 3610 and its more than enough.