2010-05-19

SharePoint 2010 Excel Services - "The workbook cannot be opened."

Setting up a new SharePoint 2010 farm "by-the-book" introduces some extra tasks getting the service and pool accounts right. I was using a unique account for Excel Services and Performance Point services, but was getting the very generic error:

"The Workbook cannot be opened."

A quick Google search sent me to this article by Jeremy Jameson.

The conclusions here are that again there are powershell commands that will do the trick:

$w = Get-SPWebApplication
$w[0].GrantAccessToProcessIdentity("domain\account")

(per web application)

No comments: