After the SharePoint administrator has installed, configured, and activated Office Web Apps, end users might receive an error message when they try to view or edit Microsoft Word, Microsoft Excel, Microsoft PowerPoint, or Microsoft OneNote documents in the browser.
These errors might occur for one or more of the following reasons: (Microsoft recommendations)
The SharePoint administrator can avoid end users' seeing error messages while he or she finishes additional deployment tasks to deploy Office Web Apps on a live production server. We recommended that you enable the OpenInClient feature on existing site collections before you run Setup.
Activate the Office Web Apps feature for the site collection. For information about how to activate the Office Web Apps feature for a site collection.
On the Central Administration Web site, in Application Management, click Manage services on server.
On the Services on Server page, do the following:
These errors might occur for one or more of the following reasons: (Microsoft recommendations)
- The SharePoint administrator has run Office Web Apps Setup, which configures the default open behavior for SharePoint to open Microsoft Word, Excel, PowerPoint, and OneNote documents in the browser by using their associated Web application. However, the SharePoint administrator has not yet started the services, created the service applications, and activated the Office Web Apps feature.
- The Office Web Apps services are not started on the Web front-end server.
- The Office Web Apps service applications and proxies have not been created.
- The Office Web Apps service applications proxies are not associated with the proxy group of the Web application that the site collection belongs to.
- There might be a problem with the permissions for the service account that is used to run the Web application or one of the Office Web Apps services: Excel Calculation Services, PowerPoint Service, or Word Viewing Service. The Web application and service applications must have the appropriate permissions to access the content databases and the configuration database.
Resolution:
How to verify that the services has been properly created or not / How to check the status of the services on the servers in the farm:
- In the list of services on the selected server, verify that Excel Calculation Services, PowerPoint Service, and Word Viewing Service exist and are started. If a service is not started, click Start.
- Click the Server button at the top, click Change Server, and then in the Select Server dialog box, click a different server name.
- Repeat these steps until you have verified that the services exist and are started on all servers in the farm.
Verify that the Office Web Apps service applications and proxies have been created by doing the following:
- On the Central Administration Web site, in Application Management, click Manage service applications.
- On the Manage Service Applications page, verify that there the following kinds of service applications exist:
- Excel Services Application Web service application
- PowerPoint service application
- Word Viewing service application
- On the Central Administration Web site, in Application Management, click Manage web applications.
- On the Web Applications Management page, select the Web applications that the site collection belongs to, and then clickService Connections.
- On the Configure Service Application Associations page, verify that the following kinds of service application proxies are associated with the Web application:
- Excel Services Application Web service application proxy
- PowerPoint service application proxy
- Word Viewing service application proxy
Hello,
ReplyDeleteWe've just migrated from Sharepoint 2007 to 2010 and our Pcs from XP with Office 2003 to W7 with Office 2010 and some of the PCs (hopefully just a few of them as far as we know... but may be we haven't had more report cause we've just started the migration, for less than 50 out of 6000 pcs to go) have this error when they try to open xlsx files on sharepoint. Every other extensions work fine (xls is fine, docx, pptx also, it's only xlsx that has the issue).
Would you have an idea what it could be ?
here are the basic things that we can check:
Delete1. Verify that the application pool account for Excel Calculation Servies has the right credentials.
2. Check if your excel services is running
3. Check if your server have this hotfix installed : KB976462
4. Check if your web application has Excel service connection – this part was missing in my case. Go to Central Admin > Manage Webapplications. Click application that hosts your site collection. Click “Service Connections”. Check if your Excel Service Application is ticked. If not change connections from default to custom and tick this Service.
Imp note: If, for some reason, you don’t want files to be open in browser but you want them to be always open in client application, you can do it in two ways:
1. All sites at once – this is tricky but you need to go to Central Administration > Site Settings > Site collection features and turn on this feature – “Open Documents in Client Application By Default”.
2. On document library level – you can go to Library Settings > Advanced settings and change “Default open behavior for browser-enabled documents” to “Open in the client application” – This will change behaviour only for this one document library
In case of any queries/questions regarding the above mentioned information then please let me know, Thank you
I have An Excel Web Access Webpart.I want a custom error message to be displayed when invalid excel workbook is trying to be imported.Step By Step Explanation is
ReplyDeleteexpected as I am new To sharepoint.
Default Message Shown is:
Unable to process the request.
Wait a few minutes and try performing this operation again.
PLease HElp!!
I am Using Sharepoint 2010...Any Help Is Welcome.
ReplyDeleteNivee,
ReplyDeleteif you check the ULS logs i.e. SP logs then you will come to know about the exact error message.
How 2 check the ULS logs:
C:\program files\common files\Microsoft Shared\web server extensions\14\Logs
open the site where the webpart is placed. as soon as the error comes out then you can check the logs for exact exception.
You can also check the event viewer for detail exception thrown.
let me know in case of any queries, Thank you
Thanks..I could trace the file in which the exception was logged..But not able to find the exact exception..How do you I check Event Viewer??Moreover,I want To customise the error message everytime i import an invalid excel book..
ReplyDeletePlease Help!!! Its Really Urgent..
ReplyDeletestart-> cmd-> eventvwr : this will opens up the event viewer page
ReplyDeletesee, you will not get exact error message in GUI but available in logs only.
may be you can provide ur logs here and i can check and review
Thanks For Looking into the matter.I have mailed you the log file which was created when the error ocurred.
ReplyDeleteThanks for your patience...I have checked the logs but nothing useful related to the error. could you please turned on the verbose logging and check the results ?
ReplyDelete