"automation error" "unspecified error"

[ML Purdy]

When opening Excel, I get multiple instances of this error in a Microsoft
Visual Basic error box. It also happens when I open an existing spreadsheet
and when I edit the worksheet.

There is no error number.

Everything seems to work fine, it is just annoying as heck.

I have tried a repair, and a repair/reinstall. Neither has worked.

I have not uninstalled Office and reinstalled it.

Can anyone help?

Thanks in advance.

 

[Jim Thomlinson]

Try removing any addins that you have. Also remove personal.xls from the
xlStart folder. Both of those can have code that would run when you open XL
and or a spreadsheet. If that solves your problem then we just need to narrow
down which one is causing the problem...

 

[Dave Peterson]

Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

 

[ML Purdy]

A very big THANK YOU to both of the gentlemen who assisted with this post.

 

[Giriraj]

Thank you Dave/Jim and Purdy for sharing this in the forum. I also came
across the same error and this post was very helpful. I started excel in safe
mode and completed detect and repair. This seems to have resolved the problem!

Thanks once again.