Showing posts with label 8000401a. Show all posts
Showing posts with label 8000401a. Show all posts

Wednesday, March 25, 2015

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8000401a.

While working with excel in one of my SharePoint site with excel, I got an error as “Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8000401a” as shown the image below
















This is the issue related to permissions for excel application in the server. We can fix the issue by the steps below.

Open Component services by entering dcomcnfg in Run.

In Component Services navigate to Component Services->Computers->My Computer->DCOM Config->Microsoft Excel Application. Right click and select Properties option as shown below.





























Select “Identity” in top, “Which user account do you want...” section, select “This user” and enter the account having admin control on the machine.


In the security section, Under "Launch and Activation Permissions", Choose "Customize", Click "Edit" button, Add the everyone account and add all the Permissions as shown below.



Do the same thing in "Access Permissions" and "Configuration Permissions". Now we can run excel without errors. 

Hope this helps.