dannyr86
asked on
Microsoft Excel 2013 Runtime Error
I have a user who opens up excel and it gives him a Microsoft Visual Basic Message. Run-time error 1005 Automation ID retrieval failed.
Surone1
hard to answer without more information. for example the line of code where it breaks. the word automation makes me guess it might have to do with components or references that are missing or another version. but i would not rule out region settings on the machine.
ASKER
I started excel in safe mode and did not get the error
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I unchecked them closed out of excel went back in and still got the message. When back to preferences and the items were checked again.
did you save the document before closing?
and just unchecking the references is not the way to go. it's better to install them in case they are actually used in the project.
if you do not know what you need then just post here what the missing references are and what Operating System they should be for.
The method that I suggested always works for me after closing and re-ppening the workbook.
ASKER
it happens every time i open excel and a new workbook.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i did a repair on it. I am going to try to create a new profile and see what happens
ASKER
I created a new profile and it is not happening on the new profile
ASKER
It doesn't show up anymore. It was some add-in I didn't see