A
Adam
This is a strange one. I have an Excel workbook that was created in
Excel XP. It has 4 total sheets -- 2 with data that's calculated, and
2 that are just for data lookups. Most of the functions employed are
standard... included in Excel's library. It also uses 2 custom
functions written in VBA running some higher level mathematical
algorithms.
System Specs: Pentium 4, 3.4 GHz (single-core, non-HT), 1.5 GB DDR
RAM, 80GB PATA.
Calculation Time:
Excel XP -- 1 minute, 45 seconds
Excel 2003 -- 8 minutes
I have another computer that has Excel 2007 installed which, unlike
previous versions, is multi-threaded.
System Specs: Core2 Duo E4400, 2.0GHz, 4GB DDR2 RAM, 80GB SATA.
Calculation Time:
Excel 2007 -- 3 minutes, 20 seconds
I cannot for the life of me figure out why Excel XP could be 5 times
faster than Excel 2003 running on the same system, and twice as fast
as Excel 2007 running on a much more powerful system.
Any Excel gurus out there that have any ideas?
I have already tried resaving the file in 2007's new XLSM format, but
it's just as slow. Turning screen refreshing off and making
calculations manually as part of the macro do not speed up the
calculations either.
Excel XP. It has 4 total sheets -- 2 with data that's calculated, and
2 that are just for data lookups. Most of the functions employed are
standard... included in Excel's library. It also uses 2 custom
functions written in VBA running some higher level mathematical
algorithms.
System Specs: Pentium 4, 3.4 GHz (single-core, non-HT), 1.5 GB DDR
RAM, 80GB PATA.
Calculation Time:
Excel XP -- 1 minute, 45 seconds
Excel 2003 -- 8 minutes
I have another computer that has Excel 2007 installed which, unlike
previous versions, is multi-threaded.
System Specs: Core2 Duo E4400, 2.0GHz, 4GB DDR2 RAM, 80GB SATA.
Calculation Time:
Excel 2007 -- 3 minutes, 20 seconds
I cannot for the life of me figure out why Excel XP could be 5 times
faster than Excel 2003 running on the same system, and twice as fast
as Excel 2007 running on a much more powerful system.
Any Excel gurus out there that have any ideas?
I have already tried resaving the file in 2007's new XLSM format, but
it's just as slow. Turning screen refreshing off and making
calculations manually as part of the macro do not speed up the
calculations either.