Display Excel content in an Excel Web Access Web Part

Suppose that you have published an Excel workbook to a SharePoint library, and now you want to display all or part of that workbook in its own SharePoint Web Part. You can do this by using a special Web Part known as the Excel Web Access Web Part. Follow these simple steps:

1. Add an Excel Web Access Web Part to a SharePoint page

2. Connect a workbook to an Excel Web Access Web Part

3. (This is optional.) Specify navigation and interactivity settings for the Excel Web Access Web Part

Add an Excel Web Access Web Part to a SharePoint page

1. Begin with a SharePoint page open for editing.

2. In a zone on the page, choose the hypertext that says Add a Web Part.
   Panes showing available categories and kinds of Web Parts appear near the top of the page.

3. In the Categories pane, choose Business Data. Then, in the Parts pane, choose Excel Web Access.

4. Choose Add to add the Web Part to the page. Keep the page open for editing.

The next step is to connect a workbook to an Excel Web Access Web Part.

Top of Page

Connect a workbook to an Excel Web Access Web Part

Important:  Before you begin the following procedure, make sure that you have created and published an Excel workbook to a library in SharePoint Server or Office 365. You cannot display a workbook in an Excel Web Access Web Part unless it is already published to a trusted library. For information about how to do that, see Share workbooks using Excel Services.

1. Begin with a SharePoint page open for editing and an empty Excel Web Access Web Part added to the page.

2. In the empty Excel Web Access Web Part, in the Select a Workbook section, click the hypertext that says Click here to open the tool pane. The tool pane opens.

3. In the Workbook Display section in the Workbook text box, specify the web site address (URL) for the workbook. If you do not know the URL, click the Browse button, select the workbook that you want to use, and then click Insert.

4. (This is optional.) To display a single item, such as a chart, table, PivotChart report, or PivotTable report, in the Named Item box, type the name of the item. This causes only that item to be displayed in the Web Part, instead of displaying the entire workbook.

5. At the bottom of the tool pane, click OK.

The workbook is now displayed in the Web Part. If you want, you can proceed to specify navigation and interactivity settings for the Excel Web Access Web Part.

Top of Page

Specify navigation and interactivity settings for a workbook displayed in an Excel Web Access Web Part

1. Begin with a SharePoint page open for editing.

2. In the upper right corner of the Excel Web Part, choose the down arrow to open the Web Part menu, and then choose Edit Web Part. The Excel Web Part tool pane opens.

3. In the Toolbar and Title Bar section and in the Navigation and Interactivity section, select the properties that you want to enable. If you want to disable a property, clear its check box.

4. At the bottom of the tool pane, choose OK to apply your changes and close the tool pane.

Top of Page