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.
dannyr86Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Surone1Commented:
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.
0
dannyr86Author Commented:
I started excel in safe mode and did not get the error
0
Roy CoxGroup Finance ManagerCommented:
You could try opening the VB Editor (Alt + F11) then Tools menu -> References ans see if any are marked Missing. If they are uncheck them.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

dannyr86Author Commented:
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.
0
Surone1Commented:
did you save the document before closing?
0
Surone1Commented:
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.
0
Surone1Commented:
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.
0
Roy CoxGroup Finance ManagerCommented:
The method that I suggested always works for me after closing and re-ppening the workbook.
0
dannyr86Author Commented:
it happens every time i open excel and a new workbook.
0
Surone1Commented:
you may just want to try unininstalling and reinstalling excel in that case.
0
dannyr86Author Commented:
i did a repair on it. I am going to try to create a new profile and see what happens
0
dannyr86Author Commented:
I created a new profile and it is not happening on the new profile
0
dannyr86Author Commented:
It doesn't show up anymore. It was some add-in I didn't see
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.