![what is a macro in excel 2010 what is a macro in excel 2010](https://pendrive-personalizados.com/wp-content/uploads/2020/05/macros-excel.jpg)
If your macro was taking 12 seconds to run before, 16 times as long would be 192 seconds, which is between 3 and 4 minutes. For instance, does it step through all the rows of the worksheet to do its processing? (Even though the macro is processing 500 rows of information doesn't mean it isn't stepping through every row on the worksheet.) The reason this might be critical is because earlier versions of Excel only used 65,000+ rows in a worksheet, whereas the latest versions can handle 16 times as many rows (over 1,000,000). :>) 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.
![what is a macro in excel 2010 what is a macro in excel 2010](https://i.go-travels.com/img/how-to/excel-macro-tutorial.gif)
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.
WHAT IS A MACRO IN EXCEL 2010 WINDOWS
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.
![what is a macro in excel 2010 what is a macro in excel 2010](https://i2.wp.com/insightextractor.com/wp-content/uploads/2013/11/open-macro-excel-2010.png)
Dave has a Windows XP system that still has an old version of Excel 97 on it.