When I try to use data analysis add in, my excel shows "automation error exception occurred" and crashes.

Question

When I click Data analysis, i get the error "Microsoft Visual Basic for Applications Automation error Exception occurred." and then it crashes. I have no idea how to fix, I've tried clicking the 1.0 check box alt f11 and I have uninstalled and reinstalled Microsoft excel but it didn't change anything.

Anyone know how to fix this?

Answer 1

Hi @Joon Sunwoo

Did you enable Analysis ToolPak and Analysis ToolPak - VBA?

It is recommended to uncheck both options > Click "OK" > Close Excel, reopen it > Check only the box of "Analysis ToolPak"add-in, click "OK" to test.

I suggest you Open the VBA Editor, go to Tools > References, and ensure all selected references are available, no referenced libraries are missing. I also suggest you check macro security settings and ensure macros are enabled.

Then, please search and go to Event Viewer > Windows Logs > Applications, check whether there is any record about this Excel crashing.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---