:>) The first thing you'll want to do is check to see how your macro is doing its work. It's very hard to make anything but the most general of comments without actually seeing the code, but that doesn't mean there isn't anything to say. Dave wonders why the macro runs so much slower on the newer version of Excel. Both machines have the same amount of memory (4 Gb) and comparable processors. On a newer machine, running Excel 2010 under Windows 7, the same macro operating on the same data takes approximately 3 to 4 minutes to run. It is able to process 500 rows of information in about 12 seconds. ![]() ![]() That system has a macro that is used to process information in a worksheet. ![]() Dave has a Windows XP system that still has an old version of Excel 97 on it.
0 Comments
Leave a Reply. |