Excel 2010 macros taking more than 4 hours for execution

Closed
Rakesh - Mar 27, 2014 at 04:53 AM
xpcman
Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
- Mar 27, 2014 at 07:59 PM
Hello,

i'm validating two excel files, for this i had write macros in 2007 and it's execute in 15min, where as the same code is taking more than 4 hours for execution in 2010.

could you please suggest the reason?



1 reply

xpcman
Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,965
Mar 27, 2014 at 07:59 PM
Has the table size increased? A Macro running on a table with 500 rows might take 30 times longer to run than when it had 50 rows.
0