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)
I'm getting "Automation error Exception occurred" (+ crash) from Excel 2016 for all macros for all workbooks. Started happening some time in the last week (same code worked fine last week)
I created a test case, empty workbook with a single module.
Option Explicit
Option Base 1
Public Sub DoIt()
MsgBox "Done"
End Sub
If I run it with F5 from inside the VBA editor, it works fine.
If I run it from Developer > Macros > DoIt, error + crash.
I tried doing a "repair" of my office installation, no change.
Thoughts?
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.
Here's the solution (since my problem hadn't gone away).
I learned this in Stack Overflow and it worked like a charm.
Check if some update has happened which is creating this issue. This can be checked in Windows updates section.
Looking at the update history, I see two recent updates: KB5015807 and KB4023057. Not seeing anything there that indicates a known issue.
Finding today that the issue is more sporadic. My simple test case is still failing, but one of my more complex workbooks is now working (wasn't yesterday)
Did you ever figure out what the issue was?
Nope, issue persists. Seems totally random too - some of my sheets show the problem, some don't, doesn't seem to be any rhyme or reason. Only thing that works reliably in running with F5 from the VBA editor.
Highly annoying.