Large Spreadsheet Too Slow 2003

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

Hi, we have an 80 mg spreadsheet which takes about 20 to recalculate with
Excel 2003 on a quad core Dell PC. Task manager of course shows that it is
only useing 25% of the processor to do the recalc. This runs 2 times / hours
24 x 7. Is it possible to dedicate more cores? How much will that improve
the recalc time?

Thanks
 
Excel 2007 will use multi-threaded calculation to improve recalc speed on
multi-core nachines, but much larger improvements are usually possible by
finding and improving the calculation hotspots/bottlenecks.

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com
 
Keith said:
Hi, we have an 80 mg spreadsheet which takes about 20 to recalculate with
Excel 2003 on a quad core Dell PC. Task manager of course shows that it is
only useing 25% of the processor to do the recalc. This runs 2 times / hours
24 x 7. Is it possible to dedicate more cores? How much will that improve
the recalc time?

Thanks
Click to expand...

takes about 20 "what" to recalculate?
seconds -- not that bad
minutes -- I'd worry

As someone else pointed out there are ways to improve calculations, but
I'd look at reducing the size of the spreadsheet as a first approach.

Bill
 
Back
Top