Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel And Multiple CPU
I use Excel for all of my estimating, my files are quit large and contain
thousands of formulas. Over time as the spreadsheet grows it becomes slower and slower to calculate. I was using a Dell computer with 1gb mem, 3.4ghz cpu and Windows XP SP2, one file in particular takes over 1.5 hours to calculate using this machine. I upgraded (I thought) to a Dell dual cpu XEON 3.2mhz machine with 2gb memory and Windows XP SP2. This was no faster, actually now it takes 1 hour and 45 minutes to calculate. Is there anything I can do to make things faster? Does Excel take full advantage of dual cpus? I would appreciate any advice. Thank you in advance Joe Gieder |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel And Multiple CPU
If you use a lot of VLOOKUPS, array formulas, and SUMIF formulas, look at the
ranges involved and try to reduce the ranges. "Joe Gieder" wrote: I use Excel for all of my estimating, my files are quit large and contain thousands of formulas. Over time as the spreadsheet grows it becomes slower and slower to calculate. I was using a Dell computer with 1gb mem, 3.4ghz cpu and Windows XP SP2, one file in particular takes over 1.5 hours to calculate using this machine. I upgraded (I thought) to a Dell dual cpu XEON 3.2mhz machine with 2gb memory and Windows XP SP2. This was no faster, actually now it takes 1 hour and 45 minutes to calculate. Is there anything I can do to make things faster? Does Excel take full advantage of dual cpus? I would appreciate any advice. Thank you in advance Joe Gieder |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel And Multiple CPU
Joe -
One standard reference is http://www.decisionmodels.com/calcsecrets.htm - Mike "Joe Gieder" wrote in message ... I use Excel for all of my estimating, my files are quit large and contain thousands of formulas. Over time as the spreadsheet grows it becomes slower and slower to calculate. I was using a Dell computer with 1gb mem, 3.4ghz cpu and Windows XP SP2, one file in particular takes over 1.5 hours to calculate using this machine. I upgraded (I thought) to a Dell dual cpu XEON 3.2mhz machine with 2gb memory and Windows XP SP2. This was no faster, actually now it takes 1 hour and 45 minutes to calculate. Is there anything I can do to make things faster? Does Excel take full advantage of dual cpus? I would appreciate any advice. Thank you in advance Joe Gieder |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Can I embed or link multiple .pdf files into or to an excel file? | Excel Discussion (Misc queries) | |||
Multiple Excel on Task bar | Excel Discussion (Misc queries) | |||
how can i open multiple excel sheets separately | Excel Discussion (Misc queries) | |||
opening multiple instances of excel | Excel Discussion (Misc queries) |