Issues with VBA after upgrading to Version 2311 (Build 17029.20108)

Anonymous
2023-12-18T11:06:31+00:00

Hi, after updating to Version 2311 (Build 17029.20108), we face seriously many issues with our Excel Macro solutions. Something we have never seen before (or at least not for a long period of time). Even things like standard commands like thisworkbook fail. We had to change to 'Monthly Enterprise Channel 2310', which fixed the issue.

Also, it happens on different computers, with different workbooks, so it's not a question about reinstall Excel or something like that.

Btw. We have been working with Macros as our Core business for more than 8 years, and have millions of lines of code. So we normally know what we do.

Is there other people in here which get the same kind of errors with VBA using this version?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
Anonymous
2024-01-10T18:50:07+00:00

All our issue was fixed by rolling back from Version 2311 (Build 17029.20108) to Version 2310 (Build 16924.20180).

We had all kind of weird issue with this Version 2311 (Build 17029.20108).

Was this answer helpful?

6 people found this answer helpful.
0 comments No comments

157 additional answers

Sort by: Newest
  1. Anonymous
    2024-07-09T05:41:44+00:00

    Hi EO,

    Sorry for not answering on your last message. But exporting and import all code modules, help clearn up the workbook. It have help my many times. I have made C# program which does this process for me.

    I have been running for 3 weeks on version 2405 without any crash at all. Very nice!

    Alex

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2024-07-08T17:01:19+00:00

    Hello !!!

    It's been almost one month since I posted here.... Excel had been behaving nicely until a few minutes ago when it CRASHED again.

    The CRASH occurred during a Save Workbook statement in VBA.

    Next the Event Viewer info:

    Hey MS, let's see if you can do 1 Excel crash, every 2 months, then 3, 4, 5, 6, 7, 8,, 9, 10, etc.

    Cheers

    Ed

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2024-06-20T07:04:53+00:00

    Hello Alexander !!!

    No, I have not... what good would it make?

    As far as leaving my other PC out of MS Insider, it clearly shows it is behind the latest "beta" version, compared to my other PC.

    I have been doing field testing = testing my VBA Code on end users PCs and 1 out of 7 happened to find an Excel HANG which it definitely, is not good news. Now I am having to develop a "Visual Guide" or video to my users to tech them how to start "Task Manager", select Excel and End Task Excel, because I have found no other way of getting of this Excel Hanging issue which I consider it ridiculous.

    Excel HANGS , as far as I have seen, during the execution of VBA code Workbook.Save.

    It hangs under no predefined circumstances. It has not been possible for me to replicate the problem. It is intermittent which I consider it to be very annoying.

    Cheers,

    Ed

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2024-06-11T18:58:57+00:00

    Sounds like a good idea Ed. Have you tried to export all your code and import it again?

    Alex

    Was this answer helpful?

    0 comments No comments