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
Olivierb61 I have experienced in similar situation. Prior to running Macro in Excel (2021 & Office 365), my 16G DDR4 RAM would more than suffice. After I have started running Macro (simple ones too), RAM usage suddenly spiked to 100%, and that caused my PC to run extremely slowly, which I was not expecting with a Ryzen 9 CPU & RTX306 GPU. So, I simply upgraded to 32G DDR4 RAM, and it did not help much, which is ridiculous. My MB can support up to 128G DDR4 RAM, but I am not going to spend a few hundred dollars to upgrade to 128G RAM, just so that I can run Excel Macro. I doubt the 128G RAM would help the situation anyways. MS should make it clear the size of RAM is needed to run Macro in Excel without slowing down PC speed.