Wednesday, March 25, 2015

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.

Saturday, March 21, 2015

We got this error with SharePoint 2007 farm custom coding.
Code downloads all the list items to excel template. Generally we can see this
error with rows updating in excel. But we haven’t changed anything from DEV to
PROD. We have investigated the error in SharePoint logs and Event logs.

We are seeing the error as there are several possible
reasons:

·The file name or path does not exist.

·The file is being used by another program.

·The workbook you are trying to save has the same
name as a currently open workbook.

After checking the issue. We have found that there is the
error with excel service. To fix that we have to create a folder.

If we are running in Windows Server 2008 64-bit/R2,

·Navigate to
C:\Windows\SysWOW64\config\systemprofile folder and create the following
directory “Desktop”

If we are running in Windows Server 32-bit

·Navigate to
C:\Windows\System32\config\systemprofile\Desktop folder and create the
following directory “Desktop”

If still you have the issue, you have to change the security
setting to run excel application using following steps,

Follow us in facebook

About Me

Having good experience in SharePoint 2007/2010 and .net applications. Currently, working on SharePoint 2013 and training people on SharePoint. Microsoft certified technology specialist, Microsoft Certified Professional developer in SharePoint 2010.