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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2024-02-05T07:25:48+00:00

    Yes.

    The issue is definitely some form of macro security bug,

    This fixes the issue for a while:

    1. Close Excel completely.
    2. Open and disable macros in the Trust Center settings
    3. Close Excel Completely
    4. Open the file that is having trouble
    5. Recompile the VBA
    6. Save the file
    7. Close excel COmpletely
    8. Open Excel and re-enable Macros
    9. Close Excel
    10. Now your file should work when opened

    The fact that this works means it must be some corruption in the security?

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2024-02-05T06:22:38+00:00

    Yes, nothing has changed on our side for over 5 years, macros worked perfectly before but now give issues since the upgrade.

    I agree MicroSoft is very silent about this issue.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-02-04T15:23:54+00:00

    We ended up reverting back to an earlier version for any computers that needed to use those files. There has been a new build that came out that caused issues in another set of files but once we recompiled those the issue went away for the time being. Waiting to see if the problems persist. I would like to know if anyone has found solutions using the current version. We were in a time crunch so recoding wasn't an option at the time.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-02-04T12:17:43+00:00

    Are you still having problems?

    Was this answer helpful?

    0 comments