Solution in 64-bit Windows 7: An error occurred while retrieving components whose CLSID is {00024500-0000-0000-c000-000000000046} in the com class factory.

The work machine is equipped with 64-bit Windows 7, which is connected to the company's accounting system. Due to a number of problems, SQL2000 cannot be installed, and vs2005 must upgrade the patch.

Finally, install the components office2007, vs2005 SP1, sql2005, and framework2.0.

The Microsoft. Office. InterOP. Excel component is required for the accoutning system, and the problem occurs exactly here.

An error occurred while uploading the Excel document: retrieving components whose CLSID is {00024500-0000-0000-c000-000000000046} in the com class factory failed.

Numerous solutions for online reading:

Common version steps

1. Enter dcomcnfg.exe in "start"-> "run" to start "Component Service"

2. Double-click "component service"> "computer"> "my computer"> "DCOM configuration"

3. Find "Microsoft Excel application" in "DCOM configuration", right-click it, and click "properties". The "Microsoft Excel application properties" dialog box is displayed.

4. Click the "ID" tab and select "Interactive User"

5. click the "Security" tab, click "Custom" on "Start and activate Permissions", and then click the corresponding "edit" button, in the pop-up "security" dialog box, add a "Network Service" user (note that you must select the computer name) and grant it the "local start" and "Local activation" permissions.

6. still "security" label, click "Custom" on "Access Permissions", and then click "edit ", in the pop-up "security" dialog box, add a "Network Service" user and grant "local access" permission.

　　

The problem lies in the 64-bit version of the machine, because after opening dcomcnfg, the item "Microsoft Excel application" cannot be found, because dcomcnfg is a 32-bit configuration, it can be fully supported in a 64-bit system.

You can see how to enable the 32-bit dcomcnfg:

1. Run: MMC-32

2. Open "file"-"add or delete management units"-select component services-click "add"-OK.

3. You can find Microsoft Excel application in the DCOM component.

 

As a result, the configuration is completed in the top way, and the website is run, the same error occurs.

Check again. The settings are still not completed.

Check iis7 settings, and finally confirm that the application pool ID needs to be set. Set the apppool ID of the website to LocalSystem or NetworkService. The problem is solved.