Excel 2010 "Object libraray invalid..."

Thanks Tushar,

I have the following checked in the references,

Visual Basic For Applications
Microsoft Excel 14.0 Object Library
OLE Automation
Ms Office 14.0 Object Library
Ms Forms 2.0 Object Library

..Still not sure!

Any other ideas on this?   I the same error with an excel macro file that ran and compiled fine on Excel2007.   

I have tried unselecting references, one by one and trying to compile but still get the error.

The only 4 remaining selected references (which I'm unable to unselect because excel complains that they are in  use) are:

Visual Basic For Applications
Microsoft Excel 14.0 Object Library

Ms Office 14.0 Object Library
Ms Forms 2.0 Object Library

At this point I'm suspecting that there is some issue with Forms 2.0 and Excel 2010.

I also ran into this problem. In my case, it was inside a PowerPoint 2010 macro that I was updating from PowerPoint 2003. I received the "Object Library Invalid..." error, and like previous posters here, did not find any MISSING references. I was able to work my way out of this problem in the following manner. Perhaps this could help someone else:

1. One by one, I double-clicked on each of the forms in my project explorer. Some forms opened, and others caused the "Object Library Invalid" error to appear.

2. For the forms that triggered the error, I did the following:

• I right-clicked on the form name in the project explorer, and chose "View Code"
• I hit F5 to run the form
• The "Object Library Invalid" message came up again
• Now, for some reason, I was able to right-click on the name of the form in the project explorer, choose "View Object", and see the form
• There were three forms in my project that triggered the error. Once I was able to see them, I noticed that they all had a ProgressBar control.
• I went through and deleted all ProgressBar controls, and I was able to compile the project

After some experimentation, I saw that the ProgressBar control was not working, even when I dragged a fresh one onto the form. I "rolled my own" progress bar with a label within a frame, and this solved my issue.

It may not be a ProgressBar in your case, but if you are still stuck, try experimenting using the steps above. It may help you find the culprit.

As the previous posts hint, this problem is caused by a broken reference. The problem here is that Excel 2010 does not explicitly show it and simply crashes.

The crash is so bad, that the file cannot be saved in Excel 2010 format (.xlsm) or in the native .xls (97-2003 format).

As Sunnyside reports, the problem can be linked to the Progress Bar control, although this is not the only one that resides in the broken reference. These are the steps to fix the problem:

1. Open the .xls file in question and click OK after getting the error mentioned above.

2. Open the Visual Basic Editor (Alt+F11)

3. Open (if they are not already open) one of the modules or code behind forms

4. Click on Tools / References...

5. In the pop-up window click on Browse...

6. Navigate to [Your Windows Directory]\System32 (it may open by default)

7. Type MSCOMCTL.OCX (you'll see it in the auto-select options before you finish typing)

8. Click Open and the reference will appear as Microsoft Windows Common Controls 6.0 (SP6)

9. Click on Debug\Compile VBAProject to verify that the problem is solved

10. Save the file.

As mentioned above, this could happen for other controls as well, but the progress bar seems to be the most popular.

I realize this is an older post, but this happened to me after applying some office updates.  I found this link which helped me.

http://www.lessanvaezi.com/delete-exd-files-to-fix-object-library-invalid-error/

Essentially VB modules get upgraded, but some older files are left behind that cause the error.  If you delete them, they will be re-created as needed and the error will go away.

Thanks so much for the help, it was a perfect solution. The error message has been very annoying.