This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
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).
Today has been a busy one. Excel has CRASHED 5 times and hang 1 time. It is unpredictable when it will either CRASH or HANG. I am executing VBA code with Excel running in SAFE mode, I have "Break On All Errors" enabled, I have "Compile On Demand" disabled, I DON'T have a single "On Error" statement in my code. I don't have missing References. My code compiles with NO errors. My code executes with NO errors. I guess I am executing VBA code in the cleanest possible environment, yet, Excel CRASHES or HANGS !!!
This is unacceptable.
Can anyone help with pointing to the Excel version before this error? I have 365 for companies
that's right, the amendment changed something, but for me it went from 10 errors per week to 5..., there are still files that reset after running the macro, others have a critical error, and still another forward and backward reference failed...
terribly irritating
there are also files that do not load at all, Run-time error''-2147417848 (80010108)'' Automation error ect...
It's definitely improved for me in the last update. I've had 2 crashes this week and have had just 1 on the 2 previous weeks.
Each time the method of opening the file with Macros disabled, recompiling, saving and thenopening with Macros enabled fixes the issue.
I have had the same problem with vba errors in my files since the update.... My method to fix it is to open the file by "open and repair" method. It usually works but after a few days the same file is once again crashed.
Repair a corrupted workbook - Microsoft Support
I am waiting for updates to fix it but after reading it I have doubts whether Microsoft takes the problem seriously...