Forum Discussion
Macros suddenly run much slower
I noticed that excel 365 macros suddenly take much longer to run. Seems to be correlated with the latest update of excel done on february 3rd on my machine
I have the same problem.
I have a large spreadsheet with one macro that takes about 10 minutes to run. When I open the spreadsheet, Excel is using about 400MB of RAM. As the macro runs, the amount of RAM increases. When it's finished, Excel is using about 1,600MB of RAM. After that, every action is Excel spikes the CPU up to 100%.
Looks to me like a recent update introduced some sort of memory release issue.
I have the same problem: Current Excel for Microsoft 365 (Win 10) is now slow running macros AND is also very slow to close after running macros. These same files and macros still run fine on Excel 2007 and Excel 2010 on alternative Win 10 PCs, and the same macros ran fine on the Excel 365 PC UNTIL recent updates of Microsoft 365 / Excel 365 on that PC.
