30-minute Excel Recalculation !

Scott Rome

Reputable
Apr 16, 2014
1
0
4,510
0
My large, complex, Excel 2013 Spreadsheet requires between 30 - 60 mins to recalculate using my 6 year-old Intel Core 2 Duo CPU. What current CPU Brand & Model is the most capable for Intense Excel 2013 number-crunching? Also, I'm on a budget, so please no 'Dual Xeon' recommendations. Thanks for the help !
 

noise

Honorable
Apr 27, 2012
388
0
10,860
42
Modern editions of Excel support multi threaded calculation so I would say you are looking at an i5 (4 cores) or i7 (4 + 4 hyper threaded) if you can afford it. You might want to look into how much RAM is being consumed during the calculation operation too in case some of the speed issues are lack of RAM causing hard disk swap outs via the paging file.
 

sunder25

Honorable
Jan 22, 2014
1,609
0
12,160
179
PCPartPicker part list / Price breakdown by merchant / Benchmarks

CPU: Intel Core i7-4770 3.4GHz Quad-Core Processor ($249.99 @ Micro Center)
Motherboard: MSI CSM-Q87M-E43 Micro ATX LGA1150 Motherboard ($109.05 @ Mwave)
Memory: G.Skill Ares Series 8GB (2 x 4GB) DDR3-1600 Memory ($68.99 @ Newegg)
Storage: Samsung 840 EVO 120GB 2.5" Solid State Disk ($82.99 @ Newegg)
Storage: Western Digital Caviar Blue 1TB 3.5" 7200RPM Internal Hard Drive ($56.98 @ OutletPC)
Case: Silverstone PS08B (Black) MicroATX Mid Tower Case ($39.99 @ Amazon)
Power Supply: XFX 550W 80+ Bronze Certified ATX Power Supply ($49.99 @ NCIX US)
Optical Drive: LG GH24NSB0 DVD/CD Writer ($15.98 @ OutletPC)
Total: $673.96
(Prices include shipping, taxes, and discounts when available.)
(Generated by PCPartPicker 2014-04-16 04:34 EDT-0400)

This build has no graphics card, but i set up a 4770 system for hyper threading.
 


Newer CPU's will help, but Excel is going to be hurt by needing blobs of single threaded performance.

Any idea where the holdup in the algorithm is? Or is it a formatting problem. Once I had an equation that had to update the contents and styling of several thousand cells on about 50 or so pages, and it dragged. After analysis, the Formatting is what ate most of the performance. As only three or four rows really needed special formatting, I changed my algorithm to, rather then painstakingly ensuring each cell had the correct format, simply ignored formatting until the end then fixed the handful of cells that broke after the fact. Got a 100x speedup doing things that way.

Point being if you have an equation taking that long, new HW probably isn't the answer.
 

ASK THE COMMUNITY

TRENDING THREADS