Excel Workbook Cannot be Opened Error – SharePoint 2010
Symptoms: A document library or Report library was created within a site on SharePoint 2010 and an excel document was uploaded. Once the file was uploaded , upon clicking on the excel document , an error is displayed saying the workbook cannot be opened as shown below
The reason behind this is usually due to the following:-
- For excel services and to open the excel document within the browser make sure you have the following Hotfix installed: Windows6.1-KB976462-v2-x64.msu available here.
- Or it 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 Service account to be a Dbowner on your content database that holds the web application
-
Or copy the following script and run it
1 2 3 4 | Add-PSSnapin Microsoft.SharePoint.PowerShell -EA 0 $webApp = Get-SPWebApplication "REPLACE_NAME_OF_WEBAPP" $webApp.GrantAccessToProcessIdentity("REPLACE_NAME_OF_SERVICEACCOUNT") "Completed" |
Related posts:
- SharePoint 2010 – Troubleshooting Cmdlets not recognized Issue
- How to get back the SharePoint WebServices applicaion in IIS if deleted, SharePoint 2010 – Vinit`s SharePoint Space – Site Home – TechNet Blogs
- SharePoint 2010 and CRM 2011 Integration
- 10 Reasons SharePoint 2010 SP1 Will Rock Your World! – SharePoint Joel’s SharePoint Land
- Service Pack 1 for SharePoint 2010 Coming Soon…
VMware vSphere 5 – Whats New & Exciting | TechHead.co.uk SharePoint 2010 build versions – SharePoint Infrastructure….From the field – Site Home – MSDN Blogs