Excel 2007 versus Excel 2003 : Speed problem
 

Microsoft had a posting at this site in late December asking for uses with
speed problems in 2007 to submit their macros to help microsoft fix this
problem.

"Alain-79 (SQEpro)" wrote:

Hi,

I have been working for several years on a rather big Addin and have already
improved the vba code several times regarding speed... puting to xlmanual the
calculation, screenupdating to false, using intermediates arrays for pasting
large amount of data on spreadsheets... working only inside usedrange...

One of the most important function of this application takes around 30
seconds on Excel 2003... And this "performance" have been aquired after
several code improvments...

I have started recently tests under Excel 2007 and the result is not that
pleasant = around 50 seconds!!!

I had the feeling that all of standard actions normaly requested regarding
speed was already taken... but have now the strong feeling I was wrong...

Any idea ? Would I be the unique one to face such speed problems...

As an example, I manipulate paste format inside a loop and I do that for the
all line while it could be done for only a few columns... Was not a problem
with 2000, 2002, 2003 // Could it be a problem with 2007 because of the
number of possible columns while I am still in compatible mode?

Whatever you can tell me about speed problems with Excel 2007 can help...
Thanks to you
Alain...

my Addin is around 50k line code...

Excel 2007 versus Excel 2003 : Speed problem
 

Joel wrote:
Microsoft had a posting at this site in late December asking for uses with
speed problems in 2007 to submit their macros to help microsoft fix this
problem.

They are probably only 1% down their inbox from December. I don't know
of any macro that actually runs faster on XL2007 and I have seen some
charting and graphics ones that run orders of magnitude slower.

Some XY calibration graphs now take so long that an estimate of the time
to complete has to be displayed and counted down to keep the user from
aborting what used to be a 2 second action in XL2003.

Regards,
Martin Brown

"Alain-79 (SQEpro)" wrote:

Hi,

I have been working for several years on a rather big Addin and have already
improved the vba code several times regarding speed... puting to xlmanual the
calculation, screenupdating to false, using intermediates arrays for pasting
large amount of data on spreadsheets... working only inside usedrange...

One of the most important function of this application takes around 30
seconds on Excel 2003... And this "performance" have been aquired after
several code improvments...

I have started recently tests under Excel 2007 and the result is not that
pleasant = around 50 seconds!!!

I had the feeling that all of standard actions normaly requested regarding
speed was already taken... but have now the strong feeling I was wrong...

Any idea ? Would I be the unique one to face such speed problems...

As an example, I manipulate paste format inside a loop and I do that for the
all line while it could be done for only a few columns... Was not a problem
with 2000, 2002, 2003 // Could it be a problem with 2007 because of the
number of possible columns while I am still in compatible mode?

Whatever you can tell me about speed problems with Excel 2007 can help...
Thanks to you
Alain...

my Addin is around 50k line code...

Excel 2007 versus Excel 2003 : Speed problem
 

I have lost my original post ???
Am I the guilty one ?
Alain-79

"Joel" wrote in message
...

Microsoft had a posting at this site in late December asking for uses with
speed problems in 2007 to submit their macros to help microsoft fix this
problem.

"Alain-79 (SQEpro)" wrote:

Hi,

I have been working for several years on a rather big Addin and have
already
improved the vba code several times regarding speed... puting to xlmanual
the
calculation, screenupdating to false, using intermediates arrays for
pasting
large amount of data on spreadsheets... working only inside usedrange...

One of the most important function of this application takes around 30
seconds on Excel 2003... And this "performance" have been aquired after
several code improvments...

I have started recently tests under Excel 2007 and the result is not that
pleasant = around 50 seconds!!!

I had the feeling that all of standard actions normaly requested
regarding
speed was already taken... but have now the strong feeling I was wrong...

Any idea ? Would I be the unique one to face such speed problems...

As an example, I manipulate paste format inside a loop and I do that for
the
all line while it could be done for only a few columns... Was not a
problem
with 2000, 2002, 2003 // Could it be a problem with 2007 because of the
number of possible columns while I am still in compatible mode?

Whatever you can tell me about speed problems with Excel 2007 can help...
Thanks to you
Alain...

my Addin is around 50k line code...