The workbook cannot be opened sharepoint 2013

I am trying to open the Excel WorkBook(.xslx) in the browser I am getting the error like this

So now I started to resolve this issue checked weather that particular user having DB Permissions or not.
We have to give db_owner Permissions to that particular user in SQL Server.
Login to DB->Security->Logins->
If user is already there check the Server roles and User Mapping Permissions.
In User mapping we have to give access to SharePoint Content DB as “db_owner”.
Once we give Permissions Check it will work.
We give Permissions using Power Shell Commands also

$p =Get-SPWebApplication –Identity<Url of the Webappliction>

Even though if you are having the same issue
Configure diagnostic logging
Central Admin->Monitoring->Configure diagnostic logging
Select the Check box for Excel Services and Check the Logs

Find with text “Error” you can find the correct error.

Lakshmi Tulasi Jasti

  • Image
  • Image
  • Image
  • Image
  • Image
    Blogger Comment
    Facebook Comment


Post a Comment