Abstract
This document will guide you to understand and set up an Excel Service Application.
1 SET UP EXCEL SERVICE APPLICATION
A. Create Excel Service Application
- Verify that the user account that is performing this procedure has the following credentials:
- The user account that performs this procedure is a Farm Administrator
- The user account that performs this procedure is a member of the Administrators group on the computer that is running a SharePoint Server.
- On Central Administration, in the Application Management section, click Manage Service Applications.
- On the Manage Service Application page, on the ribbon, click New and then click Excel Service Application.
- In the Name section, type the Excel Service application name.
- In the Application Pool section, select the Application Pool that the Excel service application will run in (if it exists), or create a new application pool.
- Click Ok.
- On the SharePoint Central Administration website home page, in the Application Management section, click "Manage Service Applications".
- On the Manage Service Applications page, click the Excel Services service application that you want to configure.
- On the Manage Excel Services Application page, click "Trusted File Locations”.
- Click on "Add Trusted File Location".
- In the Address column, click the trusted file location that you want to configure.
- Click "OK".
- Now let's check how it is working on site. Visit Site. Click on "Edit page".
- Click on "Insert" -> "Web part" and select "Excel Web Access web part".
- Open this web part in Edit mode and provide the Document Library locations.
- Provide the Document Library location and click on the rectangle as shown below:
- You will be populated with Document Library details.
- Select the document you want to add to Excel Web Access.
- Click "Insert".
- Once successfully inserted you will see the Excel file rendering in the Excel Web Access, as in: