Error "Workbook Cannot be Opened"
I got error “”Workbook Cannot be Opened” when opening *.xlsx file (but not for *.xls).
To Resolve it,
First, I deleted “Excel Service Application” and create it again. But it’s not solved.
A friend of mine solved it by adding grant access to every web apps for service account that running Excel Services Application Pool. It’s achieved by this Power Shell script:
$webApp = Get-SPWebApplication "http://WebAppURL" $webApp.GrantAccessToProcessIdentity("DOMAIN\spserviceapp")