Previous Topic Next Topic

Excel 2010 macros taking more than 4 hours for execution

Closed
Rakesh - Mar 27, 2014 at 04:53 AM
xpcman Posts 19530 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?



Related:

1 response

Answer 1 / 1
xpcman Posts 19530 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,825
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