We help IT Professionals succeed at work.

Compile Error - Object Library not found - Excel 2010

slobber72
slobber72 used Ask the Experts™
on
Hi There,

I have several spreadsheets that were working yesterday but today I am getting the error:

Compile error:
Object Library invalid or contains references to object definitions that could not be found.

ummm... what is the best way to find what reference is missing today ? It is as if  a library file has become corrupt as the same error is occuring in several workbooks. Will post workbook if it helps..

Thanks in advance for any assistance.

Regards,

Craig
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi there,

I have found the solution at the site below.

My computer did a lot of updates when i turned it on this morning, and by deleting the .EXD files and restarting excel, the problem completely disappeared.

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

Hope this helps some one else !!

Cheers,

Craig