Run-time error 1004 when creating new Excel worksheet

Question

Everytime I create a new Excel document it opens with a Visual Basics for Applications Error Run-time error '1004': Method 'Name' of object 'AddIn' failed message.

I have to press End to close the error before I can start a worksheet.

This is new behavior in the last couple of days. I tried uninstalling and reinstalling Excel but the error still appears.

I am using Excel for Mac Version 16.89 (24090815)
MacOS Sonoma version 14.4.1

Any ideas on how to get the error to stop popping up whenever I create a new worksheet or open a saved worksheet?

Thanks

Answer 1

Figured it out :)

Had to turn off the Add-in called "Acrobatexceladdin" and the errors stopped.

Answer 2

Figured it out :)

Had to turn off the Add-in called "Acrobatexceladdin" and the errors stopped.

Man, you are a genius! I loved that you were able to solve this without help. These kinds of errors are the ones that take a lot of time, and experts who have never experienced this issue will never understand. They’ll say things like: "First, make sure your computer is turned on.".

Anyway, you solved my problem. Thanks!

Likewise. This just started happening to me a couple of days ago. Turned that add-in off and the error is gone!

Answer 3

I don't have this or any other add-ins that I can find. Any other ideas?

NVM I looked at a different thread and found the location.

Tools > Excel Add-ins leads to a table of add-ins (none of which I even knew I had!) and Acrobatexceladdin is one of them. I've unchecked it. If that doesn't solve the problem, I'll turn off the others to see if that works, but from the nature of the error message it's clearly one of the add-ins.

Answer 4

I found the add-in location on a different thread. Go to Tools > Excel Add-ins and you'll find your add-ins listed with a checkbox. Uncheck "Acrobatexceladdin" and that should do it.

Answer 5

I found it in the Excel Add-ins section of the Developer tab.