MS Office SharePoint Server 2010 Excel Workbook Cannot be Opened Error

A document library or Report library was created within a site on SharePoint 2010 and an excel document was uploaded. Once the file was uploaded , upon clicking on the excel document , an error is displayed saying the workbook cannot be opened.

The reason behind this is usually due to the following:-

  1. For excel services and to open the excel document within the browser make sure you have the following Hotfix installed: Windows6.1-KB976462-v2-x64.msu available here.
  2. Or it could be because you use a custom Service Account for all your service application / Excel Services then you need to do either one of the following :
  • Add the Service account to be a Dbowner on your content database that holds the web application
  • Or copy the following script and run it
Add-PSSnapin Microsoft.SharePoint.PowerShell -EA 0
$webApp = Get-SPWebApplication “REPLACE_NAME_OF_WEBAPP”
$webApp.GrantAccessToProcessIdentity(“REPLACE_NAME_OF_SERVICEACCOUNT”)
“Completed”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: