none
Broke Excel Interop COM assembly after installing/removing 2013 beta release RRS feed

  • Question

  • Hi,

    I have recently installed Microsoft Office 2013 beta release while having 2007 already installed. When I opened a COM based Excel interop application under Visual Studio 2008, I noticed a few warnings I didn't have before. I tried to start compile the application and it still worked, but when I tried to use the feature that uses the Excel interop, I received an error.

    I immediately uninstalled Office 2013 after that, but the error stayed. I messed around in the C:\Windows\assembly folder and still didn't manage to fix it.

    After that, I went ahead and uninstalled / reinstalled Office 2007. Still no luck. Then I uninstalled Office 2007 again, deleted all the assemblies regarding interop (including the Policy ones), reinstalled Office 2007. Still nothing.

    I tried installing the PrimaryInteropAssembly. Also nothing.

    I'm out of options... What can I do?

    PS: It's not the project. I started a blank project and it has the same problem.

    Edit

    The application can still compile and will still work on other machines too. It's really just my machine that cannot run it anymore.

    Edit2

    The Warning:

    Could not determine the dependencies of the COM reference "Microsoft.Office.Interop.Excel". Erreur lors du chargement de la bibliothèque/DLL du type. (Exception de HRESULT : 0x80029C4A (TYPE_E_CANTLOADLIBRARY))

    (French part translation: "Error loading library / DLL type.")

    The error:


    • Edited by Pluc.m Friday, August 17, 2012 2:32 PM
    Friday, August 17, 2012 1:20 PM

Answers

  • Hi Pluc.m,

    Thank you for posting in the MSDN Forum.

    Based on your issue, I would suggest you a solution like this

    1. Open the regedit editor.
    2. Open HKEY_CLASSES_ROOT >> TypeLib >> {00020813-0000-0000-C000-000000000046} (The Excel PIA key is {00020813-0000-0000-C000-000000000046})
    3. Delete the lasted version folder (The Excel 2013 is 1.8)

    Also, you can refer to the following figure

    Hope this helps.

    Best Regards,


    Leo_Gao [MSFT]
    MSDN Community Support | Feedback to us

    • Marked as answer by Pluc.m Monday, August 20, 2012 11:08 AM
    Monday, August 20, 2012 2:42 AM
    Moderator

All replies

  • Hi Pluc.m,

    Thank you for posting in the MSDN Forum.

    Based on your issue, I would suggest you a solution like this

    1. Open the regedit editor.
    2. Open HKEY_CLASSES_ROOT >> TypeLib >> {00020813-0000-0000-C000-000000000046} (The Excel PIA key is {00020813-0000-0000-C000-000000000046})
    3. Delete the lasted version folder (The Excel 2013 is 1.8)

    Also, you can refer to the following figure

    Hope this helps.

    Best Regards,


    Leo_Gao [MSFT]
    MSDN Community Support | Feedback to us

    • Marked as answer by Pluc.m Monday, August 20, 2012 11:08 AM
    Monday, August 20, 2012 2:42 AM
    Moderator
  • It worked! I can't thank you enough, you saved me so much time.
    Monday, August 20, 2012 11:09 AM
  • Worked perfectly, thanks!
    Wednesday, April 10, 2013 3:18 PM
  • I have a problem with creating an Excel::_ApplicationPtr which is a com object. 

    I am getting the following error : Error loading type library/DLL. with the following line of code in c++

    Excel::_ApplicationPtr appPtr( (LPDISPATCH)app );

    It happens when I have installed Office 2010, then we install Office 2013 and we uninstall Office 2013.

    Any help would be appreciated.

    Tuesday, November 19, 2013 11:47 PM
  • What effect does the removal of this registry entry have?  I have this same issue, but I am reluctant to apply this fix without knowing what actual effects it has on the system.  My company just installed Office 2013 on all our machines so we now have 2010 and 2013 installed.

    EDIT:  Nevermind, I didn't see in the post that you already identified this key as the Excel PIA key.  Answered my own question just by re-reading your post.

    Tuesday, February 11, 2014 5:07 PM