Pages

Tuesday, June 25, 2013

SharePoint 2013: Excel Services Won't Open Excel Document

Symptom(s):
When you have Excel Services running, you cannot open an Excel doc in the browser.  You get an error message telling you to "try again later", or one that says "Couldn't Open the Workbook.  The Workbook cannot be opened." 

You are seeing Event ID 5244
Unexpected error when trying to access service settings in the configuration database. Make sure the proxy for this service application is a member of the default proxy group for the active web application. Error = ExcelServerWebServiceApplication.Local: Could not get the web application associated with this context. This indicates that the Excel Server service is not properly registered or provisioned..

Solution(s):
These were my two issues:
1. Make sure the Excel Services Service Application is in the default group
  • Go to: Central Administration -> Application Management -> Configure Service Applications Associations
  •  I only had one group - default.  Click on default (or the group you are configuring).  Make sure the box is checked next to Excel Services Application
  • Click on OK

2. Grant content database access to the managed account

The following information is from:  http://technet.microsoft.com/en-us/library/jj219698.aspx 
To grant content database access to the managed account:
  1. On a SharePoint Server application server, click Start, click All Programs, click Microsoft SharePoint 2013 Products, right-click SharePoint 2013 Management Shell, and then click Run as Administrator.
  2. At the Windows PowerShell Command Prompt, type the following (press Enter after each line):

    $w = Get-SPWebApplication -identity http://<WebApplication>
    $w.GrantAccessToProcessIdentity("<Domain>\<Username>")
Important:
If in the future you add additional content databases, you must rerun these cmdlets to ensure that Excel Services has access to the new databases.

No comments:

Post a Comment