SOLVED

Excel Macro performance issue after Windows May 2021 update

%3CLINGO-SUB%20id%3D%22lingo-sub-2481075%22%20slang%3D%22en-US%22%3EExcel%20Macro%20performance%20issue%20after%20Windows%20May%202021%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2481075%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20noticed%20extreme%20slowness%20when%20running%20an%20Excel%20macro%20after%20the%20Windows%20May%202021%20update.%20We%20have%20Windows%2010%20and%20Office%20365.%20Any%20suggestions%20on%20a%20fix%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2481075%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2485121%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Macro%20performance%20issue%20after%20Windows%20May%202021%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2485121%22%20slang%3D%22en-US%22%3EWe%20need%20the%20code%20to%20be%20able%20to%20say%20anything%20sensible%20about%20your%20question%20I'm%20afraid.%20I%20have%20not%20seen%20any%20dip%20in%20VBA%20performance%20due%20to%20this%20update.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2485758%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Macro%20performance%20issue%20after%20Windows%20May%202021%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2485758%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3Battached%20please%20find%20the%20code.%20Appreciate%20any%20feedback%20on%20improving%20performance.%20The%20Windows%20team%20is%20also%20looking%20into%20this%20on%20their%20end.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

 

4 Replies
We need the code to be able to say anything sensible about your question I'm afraid. I have not seen any dip in VBA performance due to this update.

@Jan Karel Pieterse attached please find the code. Appreciate any feedback on improving performance. The Windows team is also looking into this on their end.

best response confirmed by allyreckerman (Microsoft)
Solution
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