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: Most helpful
  1. Anonymous
    2024-02-22T14:16:11+00:00

    Exactly. I am in Excel 365. I have exported the modules, just haven't imported back in, will try that tonight. I did try and save as an .xlsx so it wipes all the code out, but same issue. I will try tonight to convert on my rolled back computer and see if the new version can open it. Something tells me it may be an i conflict with PowerPivot. I will post an update if I find anything out.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-02-22T14:04:23+00:00

    Rebuild the entire tool? Sounds like a crazy suggestion. I could understand if they wanted you to recode part of the code, and write it in another way or something. Have you tried to export all modules, delete them, and import them again?

    Also, can you say which version of Excel you are working?

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2024-02-22T12:26:19+00:00

    Has anyone had any success with testing the 2401 build that came out around the 13th? I believe this was supposed to include a fix for some of the VBA issues.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2024-02-21T20:57:32+00:00

    Good for you. I own a Microsoft 365 Home Edition. So far, it has been impossible for me to go back to 2310. Have followed every procedure suggested here, in MS websites, other sites and NONE of them work. I am trapped !!!

    Was this answer helpful?

    0 comments No comments