Hello All,

I am getting following error while opening Excel document from SharePoint site.



This issue appears when we open Excel document from Windows>> Run using below mentioned command:

Excel.exe "{File Name}"

If once I go to Excel back stage and browse for the SharePoint location, then this problem disappears.

I have a work around for this issue but main problem is that i do not have any work around when i need to open Exel document using Excel COM interop in C#.

Thanks,

Amit

Hi Amit Bansal,

Did the error appear when you open the Excel document in SharePoint site using command prompt? Did the error appear when you open the Excel document in SharePoint site by clicking it directly?

Could you provide more details about If once I go to Excel back stage and browse for the SharePoint location? It would be helpful to solve your issue if you provide more details.

Is there something special in the Excel document? Please create a simple Excel document in SharePoint site and open it and test whether this issue occurs.

Please have a try to open other kind documents and test whether this issue occurs.

Please make sure that the SharePoint site is added to IE Trusted Intranet Zone.

Please increase the connection time out (6 minutes is recommended) on the web site that host the SharePoint site on IIS.

How to increase the connection time out:

https://ahmedyousryblog.wordpress.com/2010/05/28/cant-open-excel-file-on-microsoft-office-sharepoint-server-2007-problem/

A similar post for your reference:

http://justgeeks.blogspot.com/2012/10/troubleshooting-microsoft-excel-cannot.html

Best Regards,

Dean Wang

Hello Dean,

Did the error appear when you open the Excel document in SharePoint site using command prompt?

>>Yes

Did the error appear when you open the Excel document in SharePoint site by clicking it directly?

>>No

If once I go to Excel back stage and browse for the SharePoint location?

>>In Excel 2013 i go go to Excel backstage and browse SharePoint location. After browsing SharePoint location, I do not get any error.

I have tried almost everything and still no success.

Thanks,

Amit Bansal

Hi Amit Bansal,

According to your description, the issue may be caused by authentication. You are unable to open the Excel document in SharePoint site using command prompt before you sign in the SharePoint site.

A solution can be to map SharePoint library to a network drive using WebDav. After mapping, you could type the path of WebDav to open the Excel document using command prompt.

A similar post about How to connect to a SharePoint site using WebDav for your reference:

http://support.sherweb.com/Faqs/Show/how-to-connect-to-a-sharepoint-site-using-webdav-sharepoint-2013

Best Regards,

Dean Wang