stdole2.tlb is missing or damaged

[TinaP]

I just had to replace a hard drive for one of our users and consequently reinstall MSOffice. Afterwards, when opening Excel, users get the message "One of your object libraries (stdole2.tlb) is missing or damaged. Please run Setup to install it." Administrators can access Excel with no problem. I can search for and find stdole2.tld on the hard drive. I changed the rights for users to allow modify rights, however, the error still remains. I don't get the message with any other Office applications.


The PC is running Windows XP, sp2 and Office 2003 Small Business Edition. I cannot find any help on Microsoft's web site (at least referring to XP and Office 2003) and I'm praying that the gurus at Mr. Excel can help me.

 

[BrianB]

A couple of things to try.

1. File can be corrupted. Replace it.
2. Compare the date/size of the file with machines having no trouble. If different replace or put a copy in the same folder as Excel.exe (windows checks there first)
3. file is usually in \windows\system32\ folder. If it is there, try putting a copy in the same folder as excel.exe
4. Try re-registering the file.
Start/Run and type unregsvr32 (path to file)\stdole2.tlb - Enter
Start/Run and type regsvr32 (path to file)\stdole2.tlb - Enter
should get confirmation messages.

 

[TinaP]

Thanks for your response, Brian. I'll have to wait until Monday to give everything a try, though. The user was without a computer for a day and she's trying to get caught up on her work. She said she'll do without Excel for a day to get everything else caught up.

I'll let you know how it goes.