Fix: Microsoft Excel 2007 Error stdole32.tlb

Microsoft Office is a software which we use every day. Microsoft Office is available on market since 1990, from version Office 1.0 to Office 365 which is clouding based service. When you need to access Microsoft Word or Excel, all you need is to double click on the application icon and start to use it.

Sometimes opening Microsoft Word or Excel can be a nightmare, because there are some issues with Microsoft Office package. Every time you start Microsoft Word or Microsoft Excel, Windows is trying to configure Microsoft Office 2007 which is really boring, and at the end, you get error stdole32.tlb.

The problem can occur because of file corruption or malware infection. There are a few methods which can help you to solve this issue.

Method 1: Repair Microsoft Office 2007

The first solution you can try is to repair Microsoft Office 2007. In case of file corruption, after repairing Microsoft Office, files will be renewed with the new ones. You will repair all applications in Microsoft Office, including Word, Excell, Powerpoint, Outlook, Access, and others.

  1. Hold Windows logo and press R
  2. Type appwiz.cpl and press Enter. Program and Features applet will open.
  3. Right-click on Microsoft Office 2007 and click Change
  4. Click on Repair and then click Continue

  5. After Microsoft Office 2007 finish repair, you need to restart your Windows.
  6. Run Microsoft Word 2007 or Microsoft Excel 2007

 

Method 2: Change permission for registry keys

If the first method did not solve your problem, try this method. In this method, you will change some permissions in the registry database. Before you do any registry configuration, we are recommending you to the backup registry database. Why do you need to do registry backup? In case of some misconfiguration, you can revert the registry database to the previous state when everything worked without problems.

  1. Press the Windows logo and type regedit
  2. Right click on regedit and at the bottom choose Run as administrator
  3. Click Yes to confirm running regedit as an administrator.
  4. Click File and then Export

  5. The type File name, in our example backup09072017, under Export range select All and click Save

  6. Navigate to the HKEY_CLASSES_ROOT\Excel.Chart.8
  7. Right, Click on Chart.8 and select Permissions…

  8. In the Permissionwindows click on Add
  9. Under Enter the object names to select (examples): type Everyone and then click Check Names

  10. Click OK to confirm adding object Everyone
  11. Once this is done, click on the Advanced…tab
  12. Under Ownerclick Change
  13. Under Enter the object names to select (examples): type Everyone and then click Check Names

  14. Click OK to confirm adding object Everyone
  15. After you successfully changed owner of this key, you will see that Owner is changed from System to Everyone. Click Apply and then OK.
  16. Under Permission select Everyone and enable the check box for Full Control and Read
  17. Click on Apply and OK
  18. Refresh registry database by pressing F5, this should create a new Sub key below Chart.8 called Protocol

  19. You need to change permissions of this key by repeating steps, from 8 to 17
  20. Refresh registry database again and follow the same sequence of steps to add permission to the following Sub keys StdFileEditing\Server.
  21. Close the registry editor.
  22. Restart your Windows
  23. Run Microsoft Word or Microsoft Excell

In case this solution did not solve your problem, we are recommending you to restore registry backup file. You can do it by selecting File and then Import. Navigate to registry backup file and then click Open. If you successfully restored registry to previous state, you will get notification: The keys and valued contained in backup file (C:\Users\user\Desktop\backup09072017.reg have been successfully added to the registry.

Restart your Windows.

 

Method 3: Delete Office keys from registry database

Next method is working with registry, too. Before you do any registry change, we are recommending you to backup registry database. As we said in previous method, we will do backup, so we can in case of some registry misconfiguration, revert registry database to previous state when everything worked without problems.

  1. Press Windows logo and type regedit
  2. Right click on regedit and at the bottom choose Run as administrator
  3. Click Yes to confirm running regedit as administrator
  4. Click File and then Export
  5. Type File name, in our example backup08072017, under Export range select All and click
  6. Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office.
  7. Delete subkey named Word and Excel. If some keys can not be deleted or found, please skip them, this will not influence the result of the troubleshooting.
  8. Next, You will need to open subfolders 8.0, 9.0, 10.0, 11.0 and 12.0 and then delete subkeys Excel or Word. In case you have only problem with Word, you will need to delete subkey Excel. In case you have problem with Word, you will need to delete subkey Word, and if you have problemw ith both of them, you will delete Word and Excel. If some keys can not be deleted or found, please skip them, this will not influence the result of the troubleshooting. In our example, only available version of Microsoft Office is version 12.0.
  9. Right click on Word and select We will delete subkey Word. If you have problem with Microsoft Excel, too, you will need to delete Excel subkey.
  10. Confirm key delete with Yes
  11. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office
  12. Delete subkey named Word and Excell. If some keys can not be deleted or found, please skip them, this will not influence the result of the troubleshooting. In our case, subkeys Word and Excell are missing, so we will move to next step.
  13. You will need to open subfolders 8.0, 11.0 and 12.0 and then delete subkeys Word and Excel. In case you have only problem with Word, you will need to delete subkey Excel. In case you have problem with Word, you will need to delete subkey Word, and if you have problemw ith both of them, you will delete Word and Excel. If some keys can not be deleted or found, please skip them, this will not influence the result of the troubleshooting. In our example, only available version of Microsoft Office is version 8.0, 11.0 and 12.0.
  14. Right click on Word and select We will delete subkey Word. If you have problem with Microsoft Excel, too, you will need to delete Excel subkey.
  15. Close the registry editor.
  16. Restart your Windows
  17. Run Microsoft Word or Microsoft Excel.

Method 4: Scan your System for Malware

It is possible that a certain malware or a virus has implemented itself on your computer and is triggering the “Error stdole32.tlb”. Therefore, it is recommended to scan and delete any malware or virus infecting your computer. You can read this article to completely disinfect your computer from viruses.

Method 5: Reinstallation

It was reported that in some cases the error was being triggered due to the incomplete or corrupt installation of Microsoft Office. Therefore, it is recommended to completely uninstall office from your computer and reinstall it after downloading it directly from Microsoft’s official website. In order to uninstall the office from your computer:

  1. Press the “Windows” + “I” keys simultaneously.
  2. Click on the “Apps” option.
    Clicking on “Apps”
  3. Scroll down and click on “Microsoft Office” in the list.
  4. Click on the “Uninstall” button and then on “yes” in the prompt.
    Clicking on Uninstall option
  5. Wait for the uninstallation process to be completed and then reinstall Microsoft office after downloading it from the official website.

Method 6: SFC Scan

It is possible that certain drivers installed on the operating system have been corrupted. Therefore, it is recommended to run a complete “System Files Check” scan in order to fix them. To run an SFC Scan:

  1. Press the “Windows” + “R” keys simultaneously.
  2. Type in “cmd” and press “enter”.
    Typing in “cmd”
  3. In the command prompt, type “sfc/scannow” and press “enter“.
    Typing “sfc/scannow” in the command prompt.
  4. Wait for the scan to be initiated and completed.
  5. Check to see if the issue persists.

Method 7: Deleting Temporary Files

Certain data is cached by applications to decrease loading times and to provide a better experience. However, over time this cache can be corrupted and it can interfere with important system features. Therefore, in this step, we will be deleting all the temporary files stored on the computer. For that:

  1. Press the “Windows” + “R” keys simultaneously.
  2. Type in “%temp%” and press “enter“.
    Typing in “%temp%” and press “Enter”.
  3. Press “Ctrl” + “A” to select all the files and pressShift” +”del” to completely delete them.
  4. Wait for the files to be deleted and check to see if the issue persists.

Method 8: Updating Windows

Numerous problems and error are fixed in Windows’ updates. Therefore, in this step, we will be updating the operating system in order to fix the error. For that:

  1. Press the “Windows” + “I” keys simultaneously.
  2. Click on the “Update & Security” option.
    Clicking on the “Updates & Security” option
  3. Click on the “Windows Update” option in the left pane and select the “Check for Updates” option.
    Checking for Updates – Windows Update
  4. Updates will now automatically be downloaded and installed.
  5. Restart your computer in order to apply the updates and check to see if the issue persists.

Method 9: Renaming Setup File

In some cases, renaming the setup file can help you get through this error. For that:

  1. Navigate to the following location.
    C:\Program Files\Common Files\microsoft shared\OFFICE12\Office Setup Controller

    If the file isn’t here navigate to this location.

    C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE12\Office Setup Controller|
  2. Now, rename the setup file to something other than “Setup” and save your changes.
  3. Run the application and click on “OK” when you receive the error.
  4. Check to see if the issue persists.
ABOUT THE AUTHOR

Kamil Anwar


Kamil is a certified MCITP, CCNA (W), CCNA (S) and a former British Computer Society Member with over 9 years of experience Configuring, Deploying and Managing Switches, Firewalls and Domain Controllers also an old-school still active on FreeNode.

Comments

16
    KA
    karenjs15 Dec 30, 2017

    I started repair option 1, but when I right click to ‘change’ the program in step 4, I get the pop up message
    “An error occurred while trying to uninstall Microsoft Office Home and Student 2007….Would you like to remove Microsoft Office H..S..2007 from the Programs and Features list?” Yes/No
    Obviously I do not want to actually remove it, but just change it, so I am scared to press ‘Yes’.
    Or will this just take me to the change options described by you?
    Many thanks, Karen

      KA
      K. Arrows Author Jan 14, 2018

      if you have setup disc, you can run the setup so it can auto repair.

    FG
    Fred Geiger Jan 22, 2018

    I tried all three methods, but stdole32.tlb keeps appearing and starts the configuration process.
    The problem started some time last year, and I have been using Office 2007 for many years. It therefore seems related to one of the MS operating updates.
    Any further ideas are welcome.

      KA
      K. Arrows Author Mar 8, 2018

      Can you use revouninstaller to fully uninstall office 2007 and use the revouninstaller to remove all traces, then reinstall it again. Should work.

    DA
    Dan Sep 9, 2018

    I tried both Methods 1 & 2 but neither worked. When I tried to re-install the backup registry fil, I got a message “Cannot import C:UsersuserneameDesktopbackup09082018.reg: Error accessing the registry” – now what should I do?

    SI
    Sigurd Mar 25, 2019

    There is only one way to make excel work if you got an stdole32.tlb error with the configuration starting up. You simple rename the setup file in
    C:Program FilesCommon Filesmicrosoft sharedOFFICE12Office Setup Controller
    to something else than setup. You still get the warning boks in excel – but the configuration of office does not start up and you can continue using excel

    Reply
      SW
      Shane Warren Author Sep 14, 2019

      Thank you for sharing

      CA
      CatLadyIT Nov 14, 2019

      Also delete update KB2767916

      Reply
        AQ
        aquilla Jun 14, 2022

        Hi, yes I agree and can confirm, renaming of setup file will get stop configuring office at every time you start it. Uninstalling KB2767916 will remove the excel error message. Now it is working. Thank you for the help guys!!

      MB
      Marilyn Burton May 19, 2020

      That worked. Mine was in Program FIles (x86) so if you can’t find it in one of the program files, look in the other one! C:Program Files (x86)Common FilesMicrosoft SharedOFFICE12Office Setup Controller. I renamed it zzzSetup.exe. I still get the error, but after clicking OK, it opens right up instead of running the configuration. By the way, I was able to find a “Fix it for me” for Word in the Microsoft.com website, so I don’t get the error code for that one. I was only getting it in Excel (which I use the most.) That saved me $150 by not having to buy MS Office 2019. Thanks!!

      Reply
        SW
        Shane Warren Author May 22, 2020

        Added to the article, thank you for sharing.

      MI
      mistisongpinoy Jun 18, 2020

      yes. Sigurd, this work exactly as you said. thank you.

    MK
    Madison Knight Sep 10, 2019

    I ended up uninstalling every update to Office 2007 that I could (3 of them didn’t allow me to uninstall), and once I had finished that I was able to run the Office programs without going through the slow configuration process. I’m guessing there is a particular update that is causing the trouble, but I’m not sure which one it was. … I avoided uninstalling and re-installing Office 2007 because I wasn’t sure I could find the install disk and Microsoft has removed the ability to download Office 2007 form their site. … I also attempted to turn off the automatic updating of Office, but I’m not sure I succeeded with that.

    Reply
    SW
    Shane Warren Author Sep 24, 2019

    You have to take the ownership of the registry:
    Open the registry
    Click on Edit, then click on Permissions.
    Click on Advanced, then select Permissions.
    Click on Add.
    Click on Full Control, then click Allow.
    Click on OK, close the windows and exit the registry.

    TM
    T-Money Jul 25, 2020

    delete update KB2767916 seems to work without doing any other steps.

    Reply
      FM
      Fabio Magalhaes Aug 26, 2020

      Thanks a lot, worked like a charm!