Top Pro Tips To Solve stdole32.tlb
When it comes to selecting some of the most used spreadsheet programs of Office 2007, Microsoft Excel definitely tops the list. However, sometimes while launching this application, a stdole32.tlb error occurs.
Some other causes which lead to this issue are corrupt system files, malware or virus attacks, cache files and temporary files and outdated Windows. What happens is that when the user tries to start the application, instead of starting Excel, it starts to configure Microsoft Office and following that, the error pops up on the screen.
If you get this error on your PC, then go through the below section to know complete solutions to fix this error.
How to Solve stdole32.tlb Office 2007? (Excel, Word)
Before moving into the solutions, we recommend you to perform a system restart and check if that resolves the error for you. This is because restarting the system has helped a lot of users. However, if the problem persists, take a look into other solutions listed below.
Solution 1: Try Repairing Microsoft Office 2007
First and foremost, you should make an attempt to repair Microsoft Office 2007. In doing so, corrupted files will get repaired and renewed with the new ones. Here is how you can do so easily.
- On your keyboard, press both Windows +R keys together to start the Run window. Run it as an administrator.
- Within that, make sure to enter the following,
and then hit the Enter button.
- In doing so, “Program and features” will open. After that, locate and right-click on Microsoft Office 2007 and then tap on Change.
- Click on the Repair option and then click on Continue.
- Once the Microsoft Office 2007 finishes the repairment process, make sure to reboot the Windows.
- Now, try to run Microsoft Word 2007 or Microsoft Excel 2007 and see if the issues get fixed for you. Follow the next solution, if it did not resolve the error for you.
Solution 2: Change Registry Keys Permission
It is extremely recommended to backup all the registry database before performing this step to avoid any loss of it in case something goes wrong. Once done, you need to try to change the permissions in the registry database to fix stdole32.tlb. Here is how to do so.
- Tap the Windows key on your keyboard and then type “ regedit “. Right-click on it and then run it as an administrator.
- Go to File>Export. Type the file name and then click on “All” within the Export range and then click on Save. Go to HKEY_CLASSES_ROOT\Excel.Chart.8 and then right-click on Chart.8.
- Click on Permissions and then on Add.
- Within the “Enter the object names to select (examples)” option, make sure to type “Everyone” and then select the “Check names” option. Click on Ok to confirm
- Go to the Advanced tab and within the owner section, click on Change.
- Then again, within the “Enter the object names to select (examples)” section type Everyone and then select “Check names”.Click on Ok.
- Now the owner will be changed from “System” to “Everyone”. Click on Apply and then OK.
- Within the Permissions section, click on “Everyone” and checkmark the box that says “Full Control” and “Read”. Click on Apply>Ok
- Press F5 to refresh the registry database and create a Subkey underneath Chart.8 known as Protocol.
- Repeat the steps from 3 to 9, to change the permissions of the key.
- After that, refresh the registry database and then implement the steps in the same order again so that you can add permission to StdFileEditing\Server subkeys.
- Now close the registry editor and reboot your system. Run both Microsoft Excel and Word.
If this does not resolve the issue for you, then restore the registry backup file by following the steps given below.
How to Restore the Registry Backup file?
- Go to File>Import. After that, go to the registry backup file and then click on Open.
- You will see a notification “The keys and values contained in the backup file (C:\Users\user\Desktop\backup09072017.reg have been successfully added to the registry.” after a succesful registry restore
Restart your system after doing so. Run Excel and Word to check if it resolved the error. if it still persists, follow the next solution
Solution 3: Get Rid of Office Keys from the Registry Database
Another method by which you should be able to resolve the stdole32.tlb issue is by deleting office keys through the registry database. Here is how you can do it easily.
- Press the Windows key and then type “ regedit ” within the search bar.
- Right-click on the result and then run it as an administrator.
- Click file>Export. Type the File name and select and click “All” within the Export range
- Go to HKEY_CURRENT_USER\Software\Microsoft\Office. Remove the subkey named as Word and Excel. Ignore, if you do not find some keys.
- Now open the subfolder 8.0, 9.0, 10.0, 11.0 and 12.0 and then remove the subkeys for Excel or Word. If you notice that some keys cannot be deleted or located, then ignore it.
- If the problem is with Word, then remove the Excel subkey and if the problem is for both of them, delete both of them. Ignore if you are not able to find or delete some other keys.
- Right-click on Word and choose “We will delete subkey Word”. Delete the Excel subkey if the problem resides with it as well.
- Confirm with Yes. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office.
- Remove the excel and word subkeys. Ignore or skip, if you do not find some keys as this will not cause any problems.
- Now open subfolders 8.0, 11.0 and 12.0 and then exclude the subkeys for Excel and Word. If the problem is with Excel, then remove the Excel key and if the problem is with the Word, remove the Word key. If it is with both, then get rid of both of them.
- Right-click on Word icon and then choose “We will delete subkey word”. If the problem is related to Excel, then delete Excel subkey.
- Now make sure to close the registry editor and reboot your system and run Microsoft Windows or Excel to see if it works
Solution 4: Get Rid of Temporary Files
Accumulation of temporary junk files or cache files can be another reason why you are confronting this issue. However, if such is the reason make sure to get rid of it and then run the Excel/Word again. To do so, here are the steps you need to follow.
- Press both Windows + R keys together and then type “ %temp% ”. Now press the Enter button
- Press both Ctrl and A key together to choose the files and then press Shift + delete keys to get rid of them.
- Wait for some time, so that the files can get deleted and check if the problem was solved or not. If not, follow the last solution mentioned here.
Solution 5: Update Windows
If none of the solutions solves the issue for you, then make sure to perform a Windows update. Here are the steps you need to follow for a succesful Windows Update.
- Press Windows +I and then click on “Update and Security”.
- Go to Windows update and then select “Check for updates”.
- This will lead to downloading and installation of the update.
- Restart your system to implement the new update and then check if the issue got resolved.
So these were some of the easy methods by which you should be able to fix this stdole32.tlb error on Excel.