May 16, 2013

"The workbook can not be opened" error in SharePoint 2010 with Excel

I got this error "The workbook can not be opened" in Excel Services or with the Office Excel Web App with SharePoint 2010. 

It occurs when you have a separate service user account for your service applications (which you should do to follow the best practices for permissions in SharePoint).

The fix is simple:
  1. Open Powershell for SharePoint 2010
  2. Run "$webapp = Get-SPWebApplication http://webapplicationurl"
  3. Then "$webapp.GrantAccessToProcessIdentity("domain\serviceusername")"

That's all.

Thanks to this blog for the solution:
http://wellytonian.com/2011/10/excel-workbook-cannot-be-opened-error-%E2%80%93-sharepoint-2010/

No comments:

Post a Comment