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" <(E-Mail Removed)> 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
>

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


"Chip Pearson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> 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
>>

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" <(E-Mail Removed)> wrote:

>thanks,
>Any tricks on excel 2003? excel settings i can look at? or do you think
>that will not help?
>
>
>"Chip Pearson" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> 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" <(E-Mail Removed)> 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
>>>
>

Post your code for comments


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"greg" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> thanks,
> Any tricks on excel 2003? excel settings i can look at? or do you think
> that will not help?
>
>
> "Chip Pearson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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" <(E-Mail Removed)> 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
>>>
>
>