2003 and 2007
 

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

2003 and 2007
 

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

2003 and 2007
 

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


"Chip Pearson" wrote in message
...
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

2003 and 2007
 

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)


On Thu, 14 May 2009 11:53:06 -0500, "greg" wrote:

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


"Chip Pearson" wrote in message
.. .
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

2003 and 2007
 

Post your code for comments


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"greg" wrote in message
...
thanks,
Any tricks on excel 2003? excel settings i can look at? or do you think
that will not help?


"Chip Pearson" wrote in message
...
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