I
have configured the excel services in my environment perfectly by using Microsoft
recommended articles but while testing, i have added the excel file inside
excel web access webpart to check as the functionality is properly working or
not but boom – as soon as the page loads – it throws an exception.
The workbook
cannot be opened.
This problem can be
occurring mainly because of two reasons:-
1) Custom
security settings
2) Addition
of new web application to the farm.
One
thing we need to make sure – whenever we add any web application then make sure
the proxy settings/connections should be default one. Other way will be- You
need to manually check the excel service application proxy to make sure that
the new web application is already a part of the existing set.
How to do this:-
1. SharePoint 2010
Central Administration
2. Application
management
3. Configure service
application associations
4. Ensure the excel
service application check box is tick with respect to that new web application
So
far so good! – If still the error persists then I would recommend you to check
the SharePoint logs to get the clarity on the exact root cause.
Regarding
my case, I did the same and figured it out that it’s a permission issue. Let me
tell you one thing very confidently those 9 out of 10 cases are based on
permissions issue only.
So
how to resolve this? Let me guide you step by step so that there would be no
confusion.
Resolution:-
1) Go to
any of your SharePoint 2010 Server
2) Start
3) All
programs
4) SharePoint
2010 products
5) SharePoint
2010 management Shell
6) Make sure
you run this console as “Administrator”
7) Execute
the following commands
$webApp
= Get-SPWebApplication "WebApplication URL"
$webApp.GrantAccessToProcessIdentity("Excel
Service Account Name")
What
you need to change in this –
Web application
URL -
Please enter the web application URL where you are facing the problem.
Note:
this is not a site collection URL but root URL underneath your site exist.
If
you look at the above URL then here is the isolation:
http://sharepointgalaxy – web application
URL
/sites
– wildcard variable
/sharepoint2010-
site collection name
Second
change you need to do inside the PowerShell command is:
Excel service account name – this should be in the format domain name/excelserviceaccname
Now the question is
– how to find out this excel service account name?
1) Central
Administration
2) Security
3) Configure
service accounts
4) Click
on the dropdown
5) Select
the excel service account which is running the excel service application
That’s
it- you are done! In case of any queries/questions then please let me know. I would
be more than happy to help you as well as resolves your issues, Thank you.
I m getting below error:
ReplyDeleteThe workbook that you selected cannot be opened.
The workbook may be in an unsupported file format, or it may be corrupt.
Would you like to try and open this file in Excel?
i have added the doc library in trusted location. still getting same error message
what kind of authentication is configured at the web application level?
DeleteIs the service account has already been configured for excel service in central administration?
Additionally, did you check the logs? could you please share here so that we can proceed further, thanks