Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Large Spreadsheet Too Slow 2003
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Large Spreadsheet Too Slow 2003
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Large Spreadsheet Too Slow 2003
Keith wrote:
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL 2007 VERY SLOW WITH LARGE DATA CHARTS | Excel Discussion (Misc queries) | |||
Large array, slow calcualtion of formulas | Excel Discussion (Misc queries) | |||
AutoFilter Best Practice when used in large files (slow system dow | Excel Discussion (Misc queries) | |||
very slow spreadsheet | Excel Discussion (Misc queries) | |||
Simple worksheet becomes large and slow | Excel Discussion (Misc queries) |