Setup Excel Service Application in SharePoint 2013

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

  1. 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.

  2. On Central Administration, in the Application Management section, click Manage Service Applications.

  3. On the Manage Service Application page, on the ribbon, click New and then click Excel Service Application.



  4. In the Name section, type the Excel Service application name.



  5. 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.

  6. Click Ok.

  7. On the SharePoint Central Administration website home page, in the Application Management section, click "Manage Service Applications".

  8. On the Manage Service Applications page, click the Excel Services service application that you want to configure.



  9. On the Manage Excel Services Application page, click "Trusted File Locations”.



  10. Click on "Add Trusted File Location".



  11. In the Address column, click the trusted file location that you want to configure.



  12. Click "OK".



  13. Now let's check how it is working on site. Visit Site. Click on "Edit page".



  14. Click on "Insert" -> "Web part" and select "Excel Web Access web part".



  15. Open this web part in Edit mode and provide the Document Library locations.

  16. Provide the Document Library location and click on the rectangle as shown below:



  17. You will be populated with Document Library details.

  18. Select the document you want to add to Excel Web Access.

  19. Click "Insert".

  20. Once successfully inserted you will see the Excel file rendering in the Excel Web Access, as in:


Up Next
    Ebook Download
    View all
    Learn
    View all