Forum Discussion
Dushantha820
Jun 24, 2021Copper Contributor
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
- Jun 25, 2021I 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?
Dushantha820
Jun 25, 2021Copper Contributor
JKPieterse attached please find the code. Appreciate any feedback on improving performance. The Windows team is also looking into this on their end.
JKPieterse
Jun 25, 2021Silver Contributor
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?
- Dushantha820Jun 25, 2021Copper ContributorThanks for checking. I will follow up with the Windows team as well if there were any issues with the install