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
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

157 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2024-01-24T15:15:12+00:00

    Have you reported the issue we had to MS Support? So far, I haven't had any strange issue. Fingers crossing...

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-01-25T07:44:03+00:00

    Not directly, just on here.

    The scary thing is it seems random. Sheets will work then suddenly crash.

    Disabling macros, compiling the code and reenabling macros fixes them for a short time which means it must be some sort of security conflict?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-01-25T08:00:36+00:00

    Microsoft has significantly enhanced security measures in recent years concerning the execution of macros in workbooks. This is crucial in mitigating risks associated with running potentially harmful code. As I see it, there are two effective ways to ensure that a macro can run without encountering security conflicts:

    1. Trust the folder where the file is located: By designating a folder as 'trusted,' Excel treats all macros in workbooks from this location as safe. This method is particularly useful for folders where you routinely use macros and are confident in their safety. Steps: File -> Options -> Trust Center -> Trust Center Settings -> Trusted Locations -> Add new location.
    2. Assign the macro with an EV (Extended Validation) Code Signing: Using an EV Code Signing certificate for your macros adds a robust layer of security. It not only confirms the integrity of the code – ensuring it hasn't been altered post-signing – but also verifies the identity of the person or entity that signed the code. This process is essential in a corporate environment to maintain a high standard of security.

    In our company, we are utilizing the second approach. Consequently, all our computers have a certificate listed under 'Trusted Publishers' in 'Manage User Certificates'. This setup ensures that only macros from verified and trusted sources are permitted to run, minimizing the risk of executing malicious code.

    The problem with solution number two, is you then have to make sure all users has this certificate installed, the workbook need to be sign etc. All of with can be quite time consuming.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  4. Anonymous
    2024-02-02T19:13:03+00:00

    Are you still having issues?

    Was this answer helpful?

    0 comments