2003 and 2007

[greg]

Hello, a bit of a strange question.
I have a vba program, which reads data from one sheet and writes to another
sheet.

Performance tests have shown,
7 - 11 minutes in Excel 2003
2 -3 minutes in Excel 2007
Same data, same code.

Did 2007 have huge performance gains?
Is there anything i can set in 2003 to get additional performance? Such as
shutting off calculation? Printer settings?
Something else?

thanks

 

[Chip Pearson]

Most people report the reverse -- Excel 2007 is slower than 2003. Your
performance gains are probably due the new multithreaded calculation
engine. This allows "simulatenous" (as far as that goes regarding
threads of execution) calcuation of two or more cells whose values do
not depend on the other. This can yield performance gains over the
strict and orderly cell by cell calculation in 2003.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[greg]

thanks,
Any tricks on excel 2003? excel settings i can look at? or do you think
that will not help?

 

[Chip Pearson]

Charles Williams has quite a bit of info about Excel calculations and
how to optimize them on his site at
http://www.decisionmodels.com/index.htm

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Don Guillett]

Post your code for comments