Forum Discussion
Solved
Excel Macro performance issue after Windows May 2021 update
Hi, We noticed extreme slowness when running an Excel macro after the Windows May 2021 update. We have Windows 10 and Office 365. Any suggestions on a fix? Thanks
- I see nothing obviously wrong with the code which would explain it to become slower due to any Windows update. I do expect the code can be optimized for speed, but for that I would have to know a lot more about the entire process. You could start by refactoring it a little so no window activations and selecting of cells are needed?
JKPieterse attached please find the code. Appreciate any feedback on improving performance. The Windows team is also looking into this on their end.
I see nothing obviously wrong with the code which would explain it to become slower due to any Windows update. I do expect the code can be optimized for speed, but for that I would have to know a lot more about the entire process. You could start by refactoring it a little so no window activations and selecting of cells are needed?
- Thanks for checking. I will follow up with the Windows team as well if there were any issues with the install