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
    2023-12-18T16:25:21+00:00

    Hi, we have not had any issues executing our VBA code as a macro in Excel.

    I heard that Microsoft is doing away with macros. Do you have any information on this in form of a Microsoft article stating they are doing away with macros? The only thing I have seen about this is the blocking of macros, see link here: https://learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked. Thank you.

    Also...

    I'm having issues in getting the Automate menu item to appear in Excel (which is installed on my computer).  I have tried to add it choosing "Customize the Ribbon" when right clicking in the menu area. A box displays showing me the menu options I have and Automate is already checked, see screenshot. My version of Excel is Microsoft® Excel® for Microsoft 365 MSO (Version 2310 Build 16.0.16924.20054) 64-bit (Microsoft 365 Apps for Enterprise).  Is this a versioning issue and/or a rights issue?  Is there something else that I need to install on my computer?

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2023-12-18T14:10:25+00:00

    I can't share a file with the problem, without sharing all my source code. I will try to remove some of the code, and see if I can create a test-file with the error.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  3. Anonymous
    2023-12-18T13:30:21+00:00

    I've update to that version. Could you share us a test file to reproduce your issue?

    You may upload file in private message.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2023-12-18T13:16:47+00:00

    Thanks. I have already done this, and are waiting for their response. I just wanted to share this, so other people can see that we have this kind of strange errors with the version of Excel.

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments No comments