+ Reply to Thread
Results 1 to 13 of 13

Object library invalid or contains references to object definitions that couldn't be found

  1. #1
    Forum Contributor
    Join Date
    02-14-2011
    Location
    West Valley City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    108

    Object library invalid or contains references to object definitions that couldn't be found

    I've recently been using a lot of ActiveX check boxes to hide/show certain rows when they are checked or unchecked, and upon running Excel this morning, I've found that I'm getting an error that says "Object library invalid or contains references to object definitions that could not be found" any time I try running one of my ActiveX check boxes.

    I've looked into the error a bit via google, and I've found 3 solutions that seem to work for many people, but none have worked for me thus far. The first solution I tried is navigating to appdata/roaming/microsoft/forms and then deleting all .exd files, but to my suprise, there weren't any there. I also believe someone said running Excel should create these .exd files if they are missing, but that isn't happening either.
    The second solution I tried was using the command prompt to navigate to Document and Settings, and delete the .exd files via the code "del /S /A:H /A:-H *.EXD", which also failed.
    The third solution I tried was going into the Microsoft Visual Basic --> Tools --> References --> Browse --> Navigate to System32 Folder --> Open MSCOMCTL.OCX file --> Make sure Microsoft Windows Common Controls is checked; this has also failed.

    Can anyone think of any other possible solutions I could try?

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Object library invalid or contains references to object definitions that couldn't be f

    The .exd files will be found in various folders. Do a search for them (including hidden and system folders) and then delete them (with Excel closed) and then try again.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Contributor
    Join Date
    02-14-2011
    Location
    West Valley City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    108

    Re: Object library invalid or contains references to object definitions that couldn't be f

    I went to Control Panel --> Folder Options --> View and made sure "show hidden files and folders" was checked, as well as "Hide protected operating system files" was unchecked (I'm on a vista by the way); my search isn't finding any .exd files.

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Object library invalid or contains references to object definitions that couldn't be f

    Did you specifically include those folders in the search options?
    there should be an excel folder in a similar location to the forms one you mentioned.

  5. #5
    Forum Contributor
    Join Date
    02-14-2011
    Location
    West Valley City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    108

    Re: Object library invalid or contains references to object definitions that couldn't be f

    I did a search on all my folders. I'm looking at both the Excel folder within the Roaming/Microsoft Folder, and theres only two files total (~arF599.tmp and Excel12.xlb) and an empty Folder (XLSTART).

  6. #6
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Object library invalid or contains references to object definitions that couldn't be f

    That's not the folder. When I'm back at a pc I'll look up the location.

  7. #7
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Object library invalid or contains references to object definitions that couldn't be f

    In Win7 it's:
    C:\users\user_name\appdata\local\temp\
    and within that you need to check the VBE and Excel8.0 folders

  8. #8
    Forum Contributor
    Join Date
    02-14-2011
    Location
    West Valley City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    108

    Re: Object library invalid or contains references to object definitions that couldn't be f

    Alright, In the Excel8.0 Folder I am finding a file "MSForms.exd", but even after I delete it, I'm still getting the same error (and it reappears in the folder).

  9. #9
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Object library invalid or contains references to object definitions that couldn't be f

    It should reappear once you start reloading forms in Excel. Is that the only .exd file you found?

  10. #10
    Forum Contributor
    Join Date
    02-14-2011
    Location
    West Valley City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    108

    Re: Object library invalid or contains references to object definitions that couldn't be f

    It is correctly reappearing then, but unfortunately it is not fixing the error, and yes, it is the only .exd file I'm finding anywhere on my computer (with the correct hidden / system folder settings). I also tried the other solutions I've seen around the forums listed in my original post and those have failed to work again also.

  11. #11
    Forum Contributor
    Join Date
    02-14-2011
    Location
    West Valley City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    108

    Re: Object library invalid or contains references to object definitions that couldn't be f

    Upon further playing around with my sheet, it seems my first sheet is the only one having issues. I'm able to create new ActiveX check boxes on Sheet 2 and use the same code I did on sheet 1 and it works fine, whereas I can create new check boxes on Sheet 1, but they won't run a macro or any type of code.

  12. #12
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Object library invalid or contains references to object definitions that couldn't be f

    Do you especially need ActiveX controls? The Forms ones are a lot more stable and don't suffer from this sort of problem.

  13. #13
    Forum Contributor
    Join Date
    02-14-2011
    Location
    West Valley City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    108

    Re: Object library invalid or contains references to object definitions that couldn't be f

    I could use either, and I'm actually using both. The Form check boxes prompt the error listed above, while the ActiveX simply don't do anything at all.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1