Monday, 1 October 2012

The Excel Workbook Cannot be Opened

This 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 Excel services 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 "VDM_Intranet"