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

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)


On Thu, 14 May 2009 11:22:15 -0500, "greg" wrote:

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