Delete EXD files to fix “Object library invalid” error

We have a Microsoft Word template that contains macros, which was working fine but all of a sudden in the last few days, whenever you invoke the template you get the following error:

Word has encountered a problem.

Word has encountered a problem.

If you open the template file instead of invoking a New document from it, you get a more detailed error:

Object library invalid or contains references to object definitions that could not be found

Object library invalid or contains references to object definitions that could not be found

 

This was obviously due to a change in our systems. After googling awhile, I found this article which explains that the error can happen after installing a certain Windows update: http://support.microsoft.com/default.aspx?scid=kb;en-us;932349. The update installs new versions of certain Visual Basic 6.0 Runtime files. The article provides a link to a cumulative update rollup which I tried, to no avail.

Upon further investigation, I found that the files had been updated fine. However, there is a corresponding EXD file that is created for each of the runtime files, when you use the controls provided by the runtime files in the Visual Basic designer. When the runtime files are updated, these EXD files are now invalid and hence this error occurs. To fix the error, you need to delete the EXD files and they will be re-created as needed.

These files should be located in the folder: %APPDATA%\Microsoft\Forms\

On Windows XP, it is usually located in:
C:\Documents and Settings\%USERNAME%\Application Data\Microsoft\Forms\

And on Windows Vista/7:
C:\Users\%USERNAME%\AppData\Roaming\Microsoft\Forms\

EXD files

It was easy enough to fix for myself, but others were having this problem – so I made a script that given the username deletes the files. I had users run the script (you can post it as a link on a webpage and as long as you use Internet Explorer and low security settings it can be invoked from there):

// Function to delete EXD files from user Application Data folder
//     This is to resolve an issue with Word VBA macros that use VB runtimes, which the EXDs point to
function deleteEXDs(){
    var strToPath = "%appdata%\\Microsoft\\Forms\\";
    try {
		var fso = new ActiveXObject("Scripting.FileSystemObject");
		var shell = new ActiveXObject("WScript.Shell");
	}
    catch (err) {
        alert("Could not create ActiveXObject.\nThis script should be run from Internet Explorer, \n" + 
		      "with low security settings (e.g. Intranet or Trusted Sites).");
		return;
    }
    
    try {
		var appdata = shell.SpecialFolders("AppData");
		var strToPath = appdata + "\\Microsoft\\Forms\\";
		var fldr = fso.GetFolder(strToPath);
		var noEXDs = true;

		for (var e = new Enumerator(fldr.Files);  !e.atEnd();  e.moveNext())
		{
			if (fso.GetExtensionName(e.item()).toLowerCase() == 'exd')
			{
				noEXDs = false;
				try {
					var filename = new String(e.item());
					e.item().Delete();
					alert('DELETED ' + filename);
				}
				catch (err)
				{
			        alert("Error - could not delete " + e.item() + ".\nDescription: " + err.description);
				}
			}
		}
		
		if (noEXDs) alert('No EXD files found.');
    } 
    catch (err) {
        alert("Error - could not clean up EXD files.\nDescription: " + err.description);
    }
}

Edit 26 Oct 2010:
Thanks for all the positive comments!

I noticed that this solution of deleting the EXD files is now also being mentioned in the Microsoft KB article: http://support.microsoft.com/kb/957924/en-us

Edit 1 July 2011:
Thanks to the comment below by Paul M Edwards, I updated the script to use the AppData environment variable, so it should now work with Windows newer than XP.

This entry was posted in Technology and tagged , , , , . Bookmark the permalink. Comments are closed, but you can leave a trackback: Trackback URL.

210 Comments

  1. michael
    Posted 2010/04/10 at 3:09 am | Permalink

    I was getting this error message when trying to launch a custom vb routine in AutoCAD. I found the exd file in the forms folder just as your article describes. Now the error message is gone! Thanks Lessan, you are awesome!

  2. Dream
    Posted 2010/05/06 at 5:06 pm | Permalink

    Thank you!
    It helped me a lot.

  3. David Guevara
    Posted 2010/06/05 at 2:22 am | Permalink

    I spent a lot time searching for a solution, I tried your solutions and that works!! you have saved my life.

  4. Lev
    Posted 2010/06/15 at 1:46 pm | Permalink

    I got this error running an Excel VBA add-in after installing an Office 2010 component on top of an Office 2007 installation. Thanks a lot for sharing, it helped.

  5. Terry
    Posted 2010/06/16 at 3:13 pm | Permalink

    This worked perfectly after installing Office 2010. Microsoft should add this routine to the installation package. Thank you very much for sharing this.

  6. Randy
    Posted 2010/07/07 at 12:21 am | Permalink

    This was a big pain as one of our PowerPoint add-ins mysteriously stopped working, thanks for the article!

  7. Sarah
    Posted 2010/07/07 at 5:17 am | Permalink

    I have Windows 7 and have also recently installed Office 2010 as an upgrade from 2007. Where would the .exd files be in this case? Do you delete the .box files too or just the .exd?

    Thanks.

  8. IV-an
    Posted 2010/07/08 at 12:40 pm | Permalink

    Big thanks for your advice!!! It helped me a lot. After installing Office 2010 over beta 2010, I started to have this error. Finally I deleted everything form “…\forms” folder and no problems anymore.

  9. Posted 2010/07/18 at 9:44 pm | Permalink

    This post was hard to find, but WELL WORTH THE SEARCH! I was having this problem after installing Office 2010. I was unable to open word document attachments while still in outlook until I applies this fix. Everything works as it should now, thank you!

  10. Eric
    Posted 2010/07/27 at 9:32 pm | Permalink

    This was great advice! The “object library invalid” box was coming up every time I started or shut down Word 2010. I deleted the one EXD file I saw in the folder (MScomctlLib.exd) I left the .box file (winword.box) alone. Now no problems. Thanks!

  11. Abu Maryam
    Posted 2010/08/09 at 11:44 am | Permalink

    Fantastic!!! it works!

  12. shady
    Posted 2010/08/09 at 8:43 pm | Permalink

    thanks man. you did helped me

  13. Cyrus
    Posted 2010/08/18 at 9:14 am | Permalink

    Thank very much, it is a great help to me!

  14. Sean
    Posted 2010/08/23 at 12:41 am | Permalink

    To Sarah above, you should be able to find the exd files under:

    C:\Users\Your User Name\AppData\Roaming\Microsoft\Forms

    Just delete the exd files, not box files.

    Thank the author again for saving our lives.

  15. Pegoto
    Posted 2010/08/30 at 6:31 pm | Permalink

    Great! This fixed my Excel 2010 problem!

  16. Ted Singer
    Posted 2010/08/30 at 6:52 pm | Permalink

    Deleting the .exd files fixed Reuters 3000 Xtra (Power Plus Pro) on Excel 2003. Thank you!

  17. Tommy
    Posted 2010/08/30 at 8:37 pm | Permalink

    Thanks! It helped me so much!

  18. Nataraj
    Posted 2010/09/02 at 9:56 am | Permalink

    Awesome. It works and its very simple. Hats off to you.

  19. Frank
    Posted 2010/09/02 at 5:50 pm | Permalink

    Thank you kindly….Worked perfectly as I was having trouble opening attachments…

  20. Matteo
    Posted 2010/09/08 at 5:09 pm | Permalink

    Thank you! Solved my problem

    You ‘re my hero.

  21. Vivek Vikash
    Posted 2010/09/17 at 6:14 pm | Permalink

    Thank You very much!!!

  22. Jon U
    Posted 2010/09/27 at 5:15 pm | Permalink

    Deleting the .exd file fixed SAP BPC (OutlookSoft 5.0) on Excel 2003. Thank you!

  23. Mela
    Posted 2010/10/06 at 1:40 am | Permalink

    Thanks so much for the fix. I am so glad that I found your site because I was using an add-in for my statistics class for Excel and this fix saved my life.

  24. Peter
    Posted 2010/10/07 at 3:43 pm | Permalink

    Briliant solution!!

    I work as IT specialist @ AkzoNobel and just made a PC user very happy with your simple but effective solution.

    Thanks!

  25. Fer
    Posted 2010/10/10 at 1:18 am | Permalink

    It helped a lot.
    Thanks man..

  26. Phoebe
    Posted 2010/10/10 at 10:49 pm | Permalink

    awesome. Was having series of problems importing to SharePoint 2010 to create list. This was the second half of the problem. Grazie!!

  27. Steve
    Posted 2010/10/13 at 5:05 pm | Permalink

    Many thanks for the top tip – I installed Camtasia on my machine and it stopped some Excel VBA working. Deleting the .exd’s fixed the problem.

  28. Mary
    Posted 2010/10/19 at 6:40 pm | Permalink

    Thanks so much, I was working with Oracle BI Publisher when I download OneNote 2010 on top of Office 2007. I wasn’t able to load xml data until I tried your fix. Have had a ticket with Oracle for days with no solution offered.

  29. Posted 2010/10/22 at 3:43 pm | Permalink

    Hi,

    My case is different, the error message I got is “the subject is not trusted for the specified action”. Deleting exd’s
    did not resolve my problem.. kindly help he on this.

    Thanks a lot fellow programmers… God bless!

    Gil

  30. Posted 2010/10/26 at 6:35 am | Permalink

    Sorry Gil, I haven’t come across this problem yet myself. A quick Google search came up with this link that seems promising.

    I searched for the error text you provided: “the subject is not trusted for the specified action”

  31. allen
    Posted 2010/11/02 at 9:19 am | Permalink

    thanks everyone

  32. Jason
    Posted 2010/11/19 at 10:26 pm | Permalink

    Hi guys,

    I have tried this fix in 3 different computers that were having the issue when running Excel 2003, and it worked perfect.

    Thanks

  33. Evoleht
    Posted 2010/11/26 at 9:31 am | Permalink

    Thank you very much. it solves my problem in weeks.

  34. Carol
    Posted 2010/11/28 at 10:48 am | Permalink

    Bless you!!! (And Sean above, for giving the slightly different path in Windows 7.) You have saved us from ongoing agony!!! Thank you! Thank you! Thank you!!!!!!

  35. Mitakkinen
    Posted 2010/12/05 at 9:27 pm | Permalink

    Thank you, man!
    You saved the day! :-)

  36. Renny
    Posted 2010/12/22 at 12:40 am | Permalink

    Awesome! After several weeks having to work on a Win32 VM because my new Win764 box refused to run my VBA macros in Corel DRAW… you became my savior. Hail Lessan! XD

  37. Posted 2010/12/29 at 2:08 pm | Permalink

    Works! Thank you!

  38. Jason Judge
    Posted 2011/01/15 at 1:27 pm | Permalink

    Thank you! I have had this problem with Office 2003 for many months, without finding a solution, until now.

    I had three EXD files in there, and one was zero bytes in size. I also had the exact same error message when starting up and shutting down Excel. Fixing that involved deleting an add-in file (.XLA) in:

    C:\Documents and Settings\USER\Application Data\Microsoft\FormsExcel\XLSTART\

    The Add-in file was dated 2004, so I guess is was not the *source* of the problem, but it does make the startup error go away so I can work out what needs to be reinstalled.

  39. Ricardo Mesa
    Posted 2011/01/20 at 8:27 pm | Permalink

    Awesome!!!! thanks a lot!!!
    I had some macros running on Excel 2007, updated to Excel 2010 and was having this annoying problem, perfect solution, get rid of the exd files.

  40. Han Liem
    Posted 2011/01/27 at 4:20 am | Permalink

    Thanks for sharing this. I have this problem after installing Office 2010 (from 2003). When I click the Help button on this error Microsoft does not provide any solution.

  41. Anjomi
    Posted 2011/02/09 at 2:14 pm | Permalink

    Excellent post. Fixed my problem just fine. Don’t you just love MS updates…

  42. Palanivel Periasamy
    Posted 2011/02/10 at 12:02 am | Permalink

    Simple solution. It worked. Thanks…. :)

  43. Miguel Portals
    Posted 2011/02/11 at 3:04 am | Permalink

    well, it actually doesn’t work for me…

    I just got a new laptop and the excel macro that was working with no issue on XP/Office 2007 on my old laptop does not work on XP / Office 2007 on the new laptop… this is quite annoying

    I have tried deleting all the *.EXD files

    Any other idea?

  44. Glaud
    Posted 2011/02/17 at 3:05 pm | Permalink

    Absolutely great!
    I had an Excel 2007 file with pages of VBA code + xml for a custom ribbon. It stopped working when I installed Excel 2010. I could not find the problem. I deleted the .exd file and it is all fine now. Many Thanks.

  45. Posted 2011/03/04 at 1:51 am | Permalink

    I have discovered that the Object Library Invalid error can result from another cause. I read these posts, and removed the .EXD files, and got no improvement. Then I went back to my code and examined it in detail. I discovered that I had a button called BudgetIndividual, with a procedure named BudgetIndividual_Click. In another module, I had a subroutine called BudgetIndividual. This caused no problems.

    But when I copied the BudgetIndividual procedure into the sheet module that contained the button with the same name, I got the Object Library error. This, as you may have noticed, is not an informative or helpful error message. And I have proven that it can have multiple causes. In this case, all I had to do was rename the procedure to BudgInd, and all was fixed!

  46. Posted 2011/03/04 at 8:14 am | Permalink

    Thanks Larry for posting the tip – I’ll keep it in mind, and it’ll probably help others who stumble upon this page.

  47. MoMFeI
    Posted 2011/03/09 at 10:36 am | Permalink

    Really thanks for the guideline.
    It is a very very very x999 worth lesson.

  48. Abhisheke Jain
    Posted 2011/03/14 at 5:38 pm | Permalink

    Excellent Solution with the explaination of the problem.
    Worked great for me, I had been breaking my head to solve the problem.
    Just need to get the IT guys to push this to all machines in the corporation :)

  49. Harry
    Posted 2011/04/13 at 9:51 am | Permalink

    Aweosme…it worked for me! Thanks for all your help!

  50. chi
    Posted 2011/04/15 at 3:54 pm | Permalink

    YOU SAVED MY LIFE……This stuff works!!!!

  51. Texas_Bulldog
    Posted 2011/04/21 at 5:35 pm | Permalink

    OMG, you did it!! We were convinced we were going to have to go back to an older version of Excel. You saved the day. Thanks!

  52. Mohamed Azhary
    Posted 2011/05/11 at 5:01 pm | Permalink

    Ohhhh man ,,, thank you soooo much ,,, it works perfectly

  53. Kati
    Posted 2011/05/11 at 9:38 pm | Permalink

    You are just Great.. thank you man.

  54. wasim
    Posted 2011/05/29 at 6:49 am | Permalink

    Thnx buddy,
    it work for me in VBA.

  55. Andre Steyn
    Posted 2011/06/05 at 1:31 pm | Permalink

    You are simply awesome. Thanks a lot.

  56. Posted 2011/06/05 at 3:20 pm | Permalink

    Got my Word based program back up and running again….thanks!

  57. Das
    Posted 2011/06/15 at 1:32 am | Permalink

    Thanks a Lot !!!

  58. Siggi
    Posted 2011/06/17 at 5:39 pm | Permalink

    Perfect! Thanks a lot. You saved the day.

  59. Aijaz
    Posted 2011/06/24 at 12:27 pm | Permalink

    Great! Worked for me as well! I had Office 2003 and I upgraded “only” Outlook to 2010. After that I started getting the above error at start-up for Excel. After I read your article, I deleted the MSComctlLib.exd which was the only file in that path and then restarted my Excel. The error vanished and I also saw that there was a new file created by same name “MSComctlLib.exd”.

    Thank You So Much!!

  60. debbie
    Posted 2011/06/30 at 5:58 am | Permalink

    OMG! Thank God i found your thread, same warning was also fixed! Thank you! :D

  61. Posted 2011/06/30 at 11:33 pm | Permalink

    This is a great tip which has been very helpful.

    One addition I would like to make is that the following path will provide the correct folder location regardless of Windows version or username by using an environmental variable:

    %APPDATA%\Microsoft\Forms

  62. Posted 2011/07/01 at 10:09 pm | Permalink

    Instead of “USER” in the paths, you can use %USERNAME%, i.e.:

    On Windows XP, it is usually located in:
    C:\Documents and Settings\%USERNAME%\Application Data\Microsoft\Forms\

    And on Windows Vista/7:
    C:\Users\%USERNAME%\AppData\Roaming\Microsoft\Forms\

  63. Posted 2011/07/02 at 6:12 am | Permalink

    Thanks Paul, I updated the post.

  64. Trevor
    Posted 2011/07/11 at 8:24 pm | Permalink

    You are a genius! I hit this minefield when upgrading to Eggshell 2010 and my addin in 2003/2007 fell over spectacularly. Thank you 10^6.

    Trevor

  65. vish
    Posted 2011/07/25 at 5:43 am | Permalink

    Thanks a bunch mate

  66. Crow
    Posted 2011/08/09 at 7:35 pm | Permalink

    Worked like a charm in Win 7 – thanks very much.

  67. Richard
    Posted 2011/08/11 at 3:23 pm | Permalink

    Thanks so much for this. This “works a treat” as they say across the pond. How do I invoke the script? What do I need to save it as?

  68. Vinayak
    Posted 2011/08/11 at 4:12 pm | Permalink

    Excellent, thanks a bunch !!

  69. Posted 2011/08/12 at 7:13 am | Permalink

    You can save the script as a javascript file (e.g. script.js). If you then double-click on it it should work.

    You can also link to it from a web page, and if you are running Internet Explorer with low security settings when you click on the link the script will have access to the local filesystem and do what it needs to do. Of course, the low security settings should only be used in a protected environment otherwise it will expose you to dangerous scripts on the internet. So you would add only the webpage you have hosted it on (preferably on your intranet) to the Trusted Sites group, or something like that.

  70. Djilli
    Posted 2011/08/12 at 12:39 pm | Permalink

    Hello;

    Greate your solution is working fine … Thanks very much genius!

  71. Aldo David
    Posted 2011/08/12 at 6:48 pm | Permalink

    Dear Lessan… from now on you’re my new personal hero. Thank you very much!

  72. LExts
    Posted 2011/08/31 at 11:56 am | Permalink

    Thank you very much. I wanted to destroy my computer.

    :))))))

  73. Posted 2011/09/07 at 10:23 pm | Permalink

    Works a treat, thanks for sharing!

  74. Ted
    Posted 2011/09/12 at 7:37 am | Permalink

    You cannot imagine how much trouble I’ve had with this in the past,thank you sooo much.
    I do search engine optimization for Kona, Hilo, and Waimea on the Big Island in Hawaii.

  75. Jo
    Posted 2011/09/14 at 12:12 pm | Permalink

    Very Nice. This error appeared to me when I switched from Office 2000 to Office 2010. Now by deleting the EXD I do not have the problem anymore. However hope that deleting this EXD will not affect another thing,

    Sheers

  76. Marie
    Posted 2011/09/21 at 3:10 pm | Permalink

    Thank you very much!!! You saved my project!

  77. Max
    Posted 2011/09/27 at 5:23 pm | Permalink

    Thanks for this post!
    It was really helpfull, and easy to understand.

  78. Pbertu
    Posted 2011/09/28 at 11:00 pm | Permalink

    Hi! I’ve received the same error, but with no previous Excel upgrade. I have been using Excel 2003 on Win XP for a while.

    Only see the error when I run a particular XLS that uses lots of macros and DDE to communicate with another application. The rest of the XLSs, even those with macros,work just fine. After I receive the error message, VBA Editor stops at the definition of a sub() function.

    Any ideas? I’ve tried already deleting the .EXD files, to no avail. Thanks!

    pbertu

  79. MBonda
    Posted 2011/10/06 at 12:19 am | Permalink

    Awesome! Thank you ! Thank you! I found this site that exactly gave me the resolution!
    Thanks dude!

  80. Sharon
    Posted 2011/10/11 at 10:00 pm | Permalink

    Thank you so much! You are my hero!

  81. Vince
    Posted 2011/10/13 at 10:17 pm | Permalink

    You have saved my sanity!!! A quick deletion of a single EXD file did the trick! Unbelievable…

  82. Nicholas Wang
    Posted 2011/10/17 at 12:10 pm | Permalink

    Works like a charm. Thank you!

  83. JoeyJacob
    Posted 2011/10/19 at 10:00 pm | Permalink

    WoW you made my day. Worked like a charm
    Thank you Thank you

  84. Heinz
    Posted 2011/10/28 at 7:36 am | Permalink

    Thanks man, saved my day too. Bloody microsoft should do that when they run the installation routine of a new office version.

  85. CC
    Posted 2011/11/17 at 6:11 am | Permalink

    Thankyou so much! Finally solved this. I too was looking at going back to an old version of Excel to solve this problem. Found nothing of value in solving this on Microsoft sites (without your references).

  86. Posted 2011/11/19 at 11:33 am | Permalink

    It really works fine. This error happened after upgrade from office 2007 to office 2010. After googling in italian I found the solution here, in English. Thank you very much. My head is safe (it was my boss’s pc!)

  87. Posted 2011/11/28 at 1:36 pm | Permalink

    Nailed it. Thanks!! Was troubling me since last couple of weeks.

  88. Xenix
    Posted 2011/12/18 at 6:05 am | Permalink

    Great!!! It really did perfectly :)

  89. jay holmes
    Posted 2011/12/21 at 8:42 pm | Permalink

    which exd files need to be deleted? I see a bunch of them but i also see some box files. do they need to be deleted too?

  90. Posted 2012/01/04 at 7:13 am | Permalink

    Thanks a lot. its really a great work.

  91. Mercy Ventura
    Posted 2012/01/14 at 7:50 pm | Permalink

    YOU ROCK!!!

  92. Vivek
    Posted 2012/01/17 at 7:05 am | Permalink

    Thnx…. It worked for me..!

  93. Bryant
    Posted 2012/01/20 at 9:39 am | Permalink

    This worked like a CHARM…thank goodness. I installed MS Project 2010 on 01/22/2012 and had tried uninstalling and going back to 2007 and nothing worked. I deleted the *.exd file and now MS Excel works perfectly.

  94. Mincho Kardjilov
    Posted 2012/01/26 at 3:47 pm | Permalink

    It’s work! Thanks so much! :)

  95. Posted 2012/02/03 at 1:38 am | Permalink

    Thank you for this solution. The moment I deleted these files all my templates worked fine again.

  96. Lost
    Posted 2012/02/03 at 5:10 am | Permalink

    Thank you very much – worked a treat!!!

  97. John
    Posted 2012/02/21 at 11:17 am | Permalink

    Lessan,thank you so much,I did a lot on seach solution for my issue,but only your solution does work and it is very simple,thank you so much again and god bless you

  98. Joe
    Posted 2012/03/05 at 1:50 am | Permalink

    Thank you very much. I wasted 3 hours trying to find an answer for this problem. Google, bing, windows support, etc, and others and not even Microsoft support for office 2010 has a clear answer. I red several website but nobody gave me a simple answer the works, until I found your solution!!

    One suggestion would be to post your solution in youtube or other high traffic website, since I am sure there are hundres of people with the same annoying problem, that would benefit from your solution. Also Microsoft should issue a warning for that specific update so people do not update the one that installs new versions of certain Visual Basic 6.0 Runtime files.

    Thank you so much.

  99. Michael
    Posted 2012/03/14 at 4:56 pm | Permalink

    Thank you so much – this worked perfectly and now my office programs open without the error message.

  100. Anjoy
    Posted 2012/03/18 at 5:52 pm | Permalink

    WOW! You’re a genius. :)) Thank u so much! I’ve been very irritated with that error until i found this solution. I don’t know how to thank u for that.

  101. MEC
    Posted 2012/03/29 at 9:54 pm | Permalink

    Thank you so much!

    I can’t say where I work, but our tech people were going to re-image my entire machine because of these errors! Wonder why they didn’t do an Internet search to find your simple & elegant solution!

    You have saved me from some major headaches! Thanks again!

    MEC

  102. DB
    Posted 2012/04/11 at 4:42 pm | Permalink

    Thank you for the information. It was an easy fix and worked with my Outlook as well

  103. Jeroen de Boer
    Posted 2012/04/11 at 5:16 pm | Permalink

    Many thanks for this solution Lessan! Worked perfect. Did not use the script as only 1 machine had this issue.

  104. Josh
    Posted 2012/04/11 at 8:17 pm | Permalink

    I used the manual method and this worked. However I wanted to save your script but I do not see what file extention this is supposed to be save as. It this a batch script or some other language?

    Thanks for the post and the help.

  105. Posted 2012/04/11 at 11:09 pm | Permalink

    You can save it as a .js file, as it is JavaScript (or JScript I guess).

  106. Vag
    Posted 2012/04/12 at 10:02 am | Permalink

    Thank you for your solution!

  107. Murali
    Posted 2012/04/12 at 4:13 pm | Permalink

    It is solved problem of pop up message “object library invalid or contains references to the object definitions that could not be found” after deleting EXD files.

    Thanks
    Murali

  108. Wladyslaw Janowski
    Posted 2012/04/12 at 5:38 pm | Permalink

    Hi,
    Just got this error after Windows Update installed various updates to MS Office 2007 and some system updates for Windows 7 2 days ago. Tried to restore the system to earlier time, uninstall recent updates a.s.o. Then I googled the text of the error message in Word and found this solution. It worked “from scratch”.
    Thank you very much for this help, as I was not able to find any solution around.
    Nice evening :)
    WJ

  109. vat
    Posted 2012/04/12 at 8:01 pm | Permalink

    it works! thanks.

  110. Dig
    Posted 2012/04/13 at 4:11 am | Permalink

    ..Thanks much! :)

  111. PetLahev
    Posted 2012/04/13 at 9:44 am | Permalink

    You saved my day!! Man, you are great. Thanks a lot

  112. Jonathan Feeke
    Posted 2012/04/13 at 9:46 am | Permalink

    This worked perfectly for me. I had ArcGIS 9.3 installed and got the same error after that ms update…too many vba code not to get me worried. Thanks

  113. Mikeeeee
    Posted 2012/04/13 at 12:28 pm | Permalink

    You are genious man………………GOOOOOOOOOOD Work.

    Appreciate your help………….

    Thank you…………

  114. Joyce
    Posted 2012/04/13 at 1:23 pm | Permalink

    On Windows XP, EXD files are usually located in:
    C:\Documents and Settings\%USERNAME%\Application Data\Microsoft\Forms\

    Thank you so much! Now I can use my excel spreadsheets without errors!

  115. Yashodhar Jain
    Posted 2012/04/13 at 6:38 pm | Permalink

    Thanks!!! Very Helpful.

  116. Steve
    Posted 2012/04/13 at 7:01 pm | Permalink

    Thankfully, yours was the first website I tried and it worked. No doubt saving me hours of frustration. THANKS!

  117. EG
    Posted 2012/04/13 at 10:10 pm | Permalink

    Thanks! Just saved my day! It was MSComctLib.exd … Seems that the last Windows update MS ran was problematic since I am not the only person today with this problem.

  118. karthik verma
    Posted 2012/04/16 at 7:12 am | Permalink

    Could you please let me know how to save the script and run it. i tried to go the forms folder but could not find any exd file

  119. ACCI
    Posted 2012/04/16 at 9:05 am | Permalink

    it saved my day!!! thanks for the quick resolution

  120. Rasmus
    Posted 2012/04/16 at 11:11 am | Permalink

    Thank you very much! Ran into this problem today and was getting really worried that my (critical) Excel-file was corrupted. You saved me hours – really appreciated!

  121. joseph
    Posted 2012/04/16 at 3:04 pm | Permalink

    My cousin has the same problem, i’m going to try to solve the problem. Is it enough to save the script as .js file without any change in it and will it work on double click on it?

  122. Edward Ross
    Posted 2012/04/16 at 5:48 pm | Permalink

    Used it today Lessan, worked great. Writers are happy. Thanks.
    Vissa OS

  123. Posted 2012/04/16 at 10:08 pm | Permalink
  124. Peerke
    Posted 2012/04/17 at 8:10 am | Permalink

    Used it today. Worked perfect. Thx. a lot !!

  125. Posted 2012/04/17 at 9:26 am | Permalink

    hallo it helped me also.

    thank you so much

  126. Nir
    Posted 2012/04/17 at 9:44 am | Permalink

    whow this was easy – thanx. it was so frustrating

  127. Posted 2012/04/17 at 1:26 pm | Permalink

    Yes, if you copy the script and save it into a .js file, then double-click on it, that should work.

  128. Paul Robins
    Posted 2012/04/18 at 10:24 am | Permalink

    Easy when you know how! Thanks very much. What a quick fix…

  129. Posted 2012/04/19 at 9:39 am | Permalink

    I had to use this fix twice recenlty on a Windows 7-64 box with Office 2007 on it.
    Other similar computers did not have this problem.
    The only thing that make this PC different is that it has Exact Globe 2003 installed – Dutch bookkeeping software.
    YMMV.
    I’ve added a short to C:\Users\%USERNAME%\AppData\Roaming\Microsoft\Forms on the user’s desktop so he can remove the offending template files himself next time this happens.

  130. maria
    Posted 2012/04/19 at 8:06 pm | Permalink

    Thank you so much. You explained how to solve this problem in plain English!!! Yay! My software now works…you’re brilliant and I’m a computer novice as you can probably tell!

  131. Bob Braun
    Posted 2012/04/19 at 10:40 pm | Permalink

    Thank you!!! this worked great.

  132. Saras
    Posted 2012/04/20 at 4:58 am | Permalink

    Sorry but this didn’t work for me. What else can I try? Appreciate the help.

  133. Saras
    Posted 2012/04/20 at 6:20 am | Permalink

    Addendum to my previous post. Out of 4 affected PCs, the solution worked for 3 of them.

  134. Spoke
    Posted 2012/04/20 at 4:53 pm | Permalink

    Thanks – this was driving me mad as the macro was working fine for a different user on my machine. Had done a system restore & it fixed it but then the update was reapplied & it broke again.

  135. Johnny Utah
    Posted 2012/04/20 at 8:59 pm | Permalink

    Thank you so much for this solution. I had to fix 5 machines that had this issue and the users who suddenly had this error were going into a frenzy as they could not work on their files!!!

  136. joseph
    Posted 2012/04/21 at 7:16 pm | Permalink

    It didn’t work, whatever I tried to do. How to make it work? How to make the previously mentioned hyperlink with ie? Please answer at my mail josephs@net.hr.

  137. Posted 2012/04/23 at 3:21 pm | Permalink

    Thank you very much. Such a simple solution and now my excel works fine again.

  138. Rajiv Vishwa
    Posted 2012/04/23 at 9:21 pm | Permalink

    Perfect!. Deleted ‘MSComctlLib.exd’ present in the ‘Forms’ folder mentioned in this blog post and it worked.
    Thanks a lot.

  139. MIchael
    Posted 2012/04/23 at 10:02 pm | Permalink

    Thank you for the deleting exd files suggestion. it worked perfectly. this error has been driving me crazy.

  140. Tamas
    Posted 2012/04/24 at 9:40 am | Permalink

    Thanks for this fix!
    It is very useful!
    I work in an IT helpdesk and I have just resolved this issue on a laptop for a user .
    Thanks to this site, I did not have to re-install Office and did not have to dispatch or anything useless thing!

  141. Posted 2012/04/24 at 10:23 am | Permalink

    Thank you for the great tip – I had to do some head scratching when I got questions from some people that had downloaded some stuff from my http://ramblings.mcpher.com site and hit this exact problem following a windows update.

    Luckily I found your post, and reproduced the advice here http://excelramblings.blogspot.co.uk/2012/04/what-do-if-you-get-dreaded-office.html

    bruce

  142. Herve Dioumbi
    Posted 2012/04/25 at 11:13 am | Permalink

    Thank a lot to you,it works fine .
    Great

  143. juliet
    Posted 2012/04/25 at 1:26 pm | Permalink

    Perfect! Thanks!!

  144. Colies
    Posted 2012/04/25 at 4:00 pm | Permalink

    Great great great, thnx a lot Lessan!!! My excel is running smooth again :)

  145. Geetesh
    Posted 2012/04/27 at 11:40 am | Permalink

    Thanks Deleted .exd files solved it.

  146. JY
    Posted 2012/04/27 at 3:15 pm | Permalink

    There are no .exd files in my system, searched by file extensions. Also searched for the location mentioned by you C:\Documents and Settings\%USERNAME%\Application Data\Microsoft\Forms\, but my machine does not have Microsoft\Forms folders in AppData. It has the following folders – C:\Documents and Settings\jyarida\AppData\LocalLow\DataMngr and there is only 1 file in DataMngr it is {7CA1F051-A4FB-4143-B263-02B41E571EED}, not sure if deleting this would result in some adverse outcome, therefore I didn’t delete it. Thought if I run the script you gave may fix the problem from all locations (if not from the location you mentioned), can you please tell me how to run the script? Or, is there any other solution?

    Thanks a lot!

  147. prasad
    Posted 2012/05/02 at 6:20 am | Permalink

    Man … Its wonderful solution…. As other one said , it saved my life …literally…

    Thanks a lot…

    Prasad

  148. Rachel
    Posted 2012/05/04 at 4:28 pm | Permalink

    Thanks so much for this quick fix. You’ve saved me hours trying to go through our IT or Helpdesk answering a hundred useless questions and then getting put off with “we’ll get back to you”.

  149. Furqan Ahmed
    Posted 2012/05/05 at 8:50 am | Permalink

    Thanks a lot for this quick & easy fix, which was driving me crazy. Another postive feature of being part of internet comunity.

    Thanks again.

  150. Mike
    Posted 2012/05/08 at 2:24 pm | Permalink

    THANKS A LOT !!!!

  151. Posted 2012/05/10 at 12:17 am | Permalink

    You’re just great and skilled. Bravo !!

    Nico

  152. Jason
    Posted 2012/05/10 at 10:35 pm | Permalink

    Thanks! Creating a new forms folder worked perfectly.

  153. Teresa
    Posted 2012/05/11 at 3:47 am | Permalink

    Great! It worked………finally. Thanks for your expertise.

  154. Posted 2012/05/12 at 9:33 am | Permalink

    it works for me.
    CORREGGERE ERRORE la libreria degli oggetti non è valida di Office 2010.
    Uscire dal programma ed andare su
    C:\Users\”nome”\Application Data\Microsoft\Forms
    Eliminare il file “la libreria degli oggetti non è valida “MSComctlLib.exd”
    Riaprire il programma !!!
    Il file si ricrea di nuovo correggendo il programma

  155. Cindy
    Posted 2012/05/15 at 10:32 pm | Permalink

    THANK YOU!!! That was THE easiest fix I’ve ever had on my computer! You guys rock!!!

  156. Napstar
    Posted 2012/05/16 at 8:29 am | Permalink

    Yo :) It worked . Thanks

  157. lord
    Posted 2012/05/17 at 9:09 am | Permalink

    Thanks a lot. It worked :)

  158. sri
    Posted 2012/05/17 at 2:20 pm | Permalink

    excellent. working fine.. thanks a lot

  159. chandan
    Posted 2012/05/19 at 1:34 pm | Permalink

    thanks a lot it worked in win7

  160. David
    Posted 2012/05/21 at 1:19 am | Permalink

    You are the man! This worked for me! Thanks.

  161. imagine154
    Posted 2012/05/21 at 1:01 pm | Permalink

    U great!!!

  162. PaolaP
    Posted 2012/05/21 at 8:47 pm | Permalink

    The solution!! Thanks a lot.

  163. zuber
    Posted 2012/05/23 at 2:46 pm | Permalink

    Hi,
    I am trying to load an COM add-in, my excel is giving me loading error.
    ———————————————————
    Could not load file or assembly ‘OSIsoft.PIDataLink.UI, Version=4.0.3.0, Culture=neutral, PublicKeyToken=c3309f0734ba2805′ or one of its dependencies. Access is denied.
    ———————————————————

    I was asked to delete EXD files, but excel ribbon is still not loading, can you help?
    Thanks

  164. Ivan
    Posted 2012/05/25 at 12:51 pm | Permalink

    Чувак, выще красавчик, на работе отдел поддержки не смог решить проблему… Спасибо большое!!!
    Thank you very much! It helped!

  165. Posted 2012/05/28 at 12:52 pm | Permalink

    thanks for giving some instructions for Microsoft data ;;

    thank u so much……

  166. Posted 2012/05/28 at 12:53 pm | Permalink

    thanks for giving some instructions for Microsoft data

    thank u so much……

  167. Ajay
    Posted 2012/05/30 at 4:13 am | Permalink

    Easy as! :)
    You are awesome. Thanks.

  168. Сергей
    Posted 2012/06/01 at 1:16 pm | Permalink

    Спасибо огромное!!!!!

  169. Meena Sehar
    Posted 2012/06/02 at 12:37 am | Permalink

    Thank you so much.I was able to fix this issue with MS-word 2007 by deleting the .exd files.

  170. Randall Wilkinson
    Posted 2012/06/04 at 5:28 pm | Permalink

    Thank you. This little problem has been plagueing me for a few weeks.

  171. AD
    Posted 2012/06/06 at 8:57 pm | Permalink

    Solved my problem with Office 2010 and BizTalk BAM plug-in. Thanks!

  172. Posted 2012/06/13 at 5:19 pm | Permalink

    Your easy fix finally solved this annoying nuisance. Thanks a LOT!

  173. May Aguilar
    Posted 2012/06/13 at 11:29 pm | Permalink

    Awesome! Thanks!

  174. hemant
    Posted 2012/06/15 at 10:56 am | Permalink

    It worked…thanks for your help….

  175. Posted 2012/06/18 at 7:55 pm | Permalink

    Depression Causes Addiction Depression is a common cause of drug addiction and alcoholism.. read more about Ambien here: http://ambienbuyonline.biz Zolpidem drug. Can I ask if the CD he gave you was for depression or was it just a general relaxation CD?

  176. Dave
    Posted 2012/06/20 at 1:38 am | Permalink

    Thanks, “spear in his side” Jn 3:16

  177. JJ
    Posted 2012/06/20 at 6:57 am | Permalink

    Fantastic Thanks Man

  178. Laszlo
    Posted 2012/06/20 at 4:11 pm | Permalink

    Thanks a lot!

  179. Lou
    Posted 2012/06/22 at 12:37 am | Permalink

    I followed your directions, but could not open the application in excel, keep getting the same error. THe application has vba excel and/or macros.

  180. riny
    Posted 2012/06/22 at 10:16 am | Permalink

    Great fix thnx for this beautifull post :D

  181. Julio
    Posted 2012/06/22 at 5:28 pm | Permalink

    Works for me!! Many many many thanks

  182. Yobamsz
    Posted 2012/06/27 at 3:25 pm | Permalink

    This worked perfectly for me and am happy. Thanks

  183. Prince Richard
    Posted 2012/06/27 at 5:24 pm | Permalink

    Thanks a ton for your post. It helped me resolve a long pending issue. I was completely lost and clueless.

    Thanks a ton again.

    Regards,
    Prince

  184. phil
    Posted 2012/06/27 at 6:07 pm | Permalink

    thanks so much for this! after much frustration trying to figure out how to fix this problem, your solution took care of it in just a few seconds! :-)

  185. Cristiam
    Posted 2012/07/04 at 3:40 pm | Permalink

    OMG! You are a Rock Star! Deep thanks for directing us with this solution.

  186. Posted 2012/07/06 at 10:47 pm | Permalink

    Its true you are a genius

  187. Posted 2012/07/06 at 11:34 pm | Permalink

    you are the man. fixed it quick

  188. Ry
    Posted 2012/07/10 at 1:30 am | Permalink

    impressive..thanks mate

  189. Thulasi
    Posted 2012/07/12 at 10:45 am | Permalink

    It worked like a charm. Thanks for sharing. Saved my time :) :)

  190. Smitha
    Posted 2012/07/18 at 9:40 am | Permalink

    Thanks.. quick fix…:-)

  191. Saras
    Posted 2012/07/24 at 9:40 am | Permalink

    I deleted the .exd files but I still get the same error message. What else can I try? This is quite urgent.
    Thanks.

  192. Shannon
    Posted 2012/07/24 at 6:37 pm | Permalink

    Thank you! Just an update for those that no longer have VB installed, trying to install the update will fail. Just skip to directly deleting the exd files

  193. Posted 2012/07/25 at 8:30 pm | Permalink

    muy bueno su mecaanica ya se como areglar el puerto de el DCR de el faren clok

  194. Volkan Orhan
    Posted 2012/07/27 at 12:16 pm | Permalink

    Thank you very much for your solution…

  195. Suresh
    Posted 2012/07/31 at 6:41 am | Permalink

    Thanks its dobe by deleting exd file, I solved this error

  196. CJ
    Posted 2012/08/01 at 4:57 am | Permalink

    Works a treat. Good work!

  197. Mikhail
    Posted 2012/08/30 at 7:23 pm | Permalink

    that did it! Installed word 2010 alongside word 2003 on xp box and started having problems. 2003 would crush when opening, 2010 throwing ‘Object library invalid’ error. After deleting esd files both words work fine with all the macros. Great hint! Thank you much!

  198. dja
    Posted 2012/09/16 at 1:49 pm | Permalink

    Thanks for your solution. Worked great.

  199. Guest
    Posted 2012/09/18 at 3:57 pm | Permalink

    Yes it works, Thanks

  200. Ash
    Posted 2012/09/19 at 1:14 pm | Permalink

    Bravo..You are the man

  201. Piyush
    Posted 2012/09/28 at 10:18 pm | Permalink

    thanks! this was very helpful… being used 3 years after you published this!

  202. Raiden
    Posted 2012/10/02 at 1:21 pm | Permalink

    i try to update my java but it says %appdata% not found.
    i read on a help forum that this is a BIG problem

    help?

  203. Ron
    Posted 2012/10/12 at 10:07 am | Permalink

    Works like a charm, thanks for this solution! After removing the .exd files, now Excel runs fine.

    To everyone, make sure you look in the appdata/roaming folder and not in the appdata/local folder (as described by Lessan).

  204. Daniele
    Posted 2013/01/28 at 7:38 pm | Permalink

    Hello I’m using Windows 7 64-bit Home premium with Office 2007 enterprise edition, Unfortunately I can’t find any C:\Users\Daniele\AppData\Roaming\Microsoft\Forms\. The folder /Forms doesn’t exists, thus I can’t find the .exd files to delete.
    What can I do? Please help me!
    Thx

  205. Posted 2013/02/04 at 8:40 pm | Permalink

    If there are no EXD files and you are still getting that error, it may be due to something else. I think there are a few other reasons for the same error message to appear. You can try searching further on Google for these – I haven’t had any experience with them myself.

  206. Vitor Patinho
    Posted 2013/02/16 at 6:27 pm | Permalink

    I Lesson, after 4 years this post is still very helpful. My situation was: I have some excel macros with a date control (DTPicker) and yesterday i need to do a change in macro and this error appear (Object library invalid or contains references to object definitions that could not be found). So, this error was created because from last time that I use the macro and yesterday I installed a application that work with VBA and probably it change the file MSComCtl2 that change the MSComCtl2.exd out of date. so, for my situation you solution works well. After delete EXD files the error missing and the new MSComCtl2.exd was generated in profile path and now I can change may macro.
    Thank you for share the problem and solution .
    Best regards, Vitor

  207. ronaldo
    Posted 2013/08/20 at 4:36 am | Permalink

    It works perfectly now. thanks a lot!

  208. Posted 2013/09/10 at 10:57 pm | Permalink

    I had 2 ESD files on my “forms” folder. I deleted them and remove them from my laptop. When I reopened Word, there were once again there, in the folder “Forms”; recreated. And Word has the same problem!

    electronics…

  209. Karen
    Posted 2014/03/03 at 3:34 am | Permalink

    I want to thank you profusely for this article, thank you, thank you, thank you! I had a problem with excel, and I didn’t know how to resolve it, and your solution worked–thank you so much.

  210. Ali
    Posted 2014/03/09 at 3:19 pm | Permalink

    Thank you very much
    This has helped me a lot

6 Trackbacks