VBA performance issue after August Updates

Question

On some organization laptops, we were facing VBA scripting performance issue at the end of August. VBA scripting reads the data from multiple excel files and in some huge for loops, write the data of each month of 12 months, each servers of few hundreds Linux vms and their each filesystem utilization data to some arrays, then update the data in those array to a new spreadsheet. After some huge for loops were executed, the excel has no responding anymore. Even in the debug mode, press F8 /step into to execute the code one by one, it seems stuck and can move to next statement after few seconds.Normally it takes 5 minutes in July, but now at least need 10 ~ 20 times of time. We tried to perform the trouble-shooting: reinstall office 365 app, but no any improvement. At the same time, on other organization laptops, VBA scripting is running well, very normal. Is there anyone have reported some similar issues[performance issue with huge for loops, array operation, update the excel cells using vba scripting] after August update deployed?

Windows10 + MS 365 (Office) Version 2408 (Build 17928.20114 Click-to-Run)

Answer 1

If your cmd is run successfully, you just need to wait it completely.

It is about two weeks for the next version update.

Answer 2

Serveral user meets same issue. It is bug on 17928.20114 version.

excel with macros running very slow after latest update - Microsoft Community

Slow Performance of VBA after Excel Version Upgrade - Microsoft Community

You may create a support ticket to Microsoft.

Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. Support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.

Get support - Microsoft 365 admin | Microsoft Learn

About how to find the admin in your organization, you can refer to How do I find my Office 365 admin

Try roll back office update as workaround.

1. Start an Office application (such as Excel), and then select File > Account. select Update Options > Disable Updates.
2. Type cmd on the start menu, right click on the Command Prompt, choose Run as Administrator
3. Copy/paste these two commands one at a time and press enter

cd %programfiles%\Common Files\Microsoft Shared\ClickToRun

officec2rclient.exe /update user updatetoversion=16.0.17830.20166

Here is version history. Change the 16.0.17830.20166 to the version number based on your channel.

Update history for Microsoft 365 Apps (listed by date) - Office release notes | Microsoft Learn

Answer 3

Updated MS 365 to Version 2408 (build 17928.20156) and it resolved the problem for me.

excel with macros running very slow after latest update - Microsoft Community

Answer 4

Hi Snow,

Thanks for your quick respond.

But nothing happened when running the command as Administrator. Network issue? have no idea.

BTW, may I know when the next update will be ready to deploy？