Important Before you can display a workbook in an Excel Web Access Web Part, you must publish the workbook to Excel Services or upload the workbook to a document library on the site.This procedure describes the specific steps that you have to take to add an Excel Web Access Web Part to an existing Web Part page. To add a Web Part to a page, you must belong to the default <Site Name> Members SharePoint group for the site.If no appropriate page exists, you might have to create a site page.To add an Excel Web Access Web Part to a Web Part page, take these steps.
This adds the Web Part to the page and displays the Select a Workbook pane.
To save changes and exit Web Part Edit mode, you can click OK at the bottom of the Web Part tool pane. Or, to stop editing and view the workbook in Display mode, click Stop Editing.This displays the Web Part that you configured to use its associated workbook on the page.
You can create a single Excel workbook that contains a variety of elements and publish the workbook to a SharePoint site. Some elements, such as charts, PivotTables and PivotCharts, and Excel tables, have unique names assigned to them automatically by Excel when you create them. These names can be important in the publish process. There may be other elements, such as worksheets, ranges of data, and sparklines, for which you must create defined names so that the publish process recognizes them as available items. After you publish your workbook with the items you want to include, you can display those items on various SharePoint pages by connecting the workbook and a single item to an Excel Web Access web part. This enables you to reuse these items in multiple locations.
On the File tab, click Save & Send, and then click Save to SharePoint.In the Save to SharePoint section, click Publish Options.In the Publish Options dialog box, on the Show tab, use the list to select Items in the Workbook.Select the named items in the list that you want to publish, and then click OK. Note that you can choose between named items in the workbook or specific (or all) worksheets in this dialog box, but you can't specify a combination of worksheets and items. For this reason, we recommend assigning a defined name to a worksheet if you want to publish entire worksheets in addition to other items, such as charts and tables.In the Save to SharePoint section, click Browse for a location, and then click Save As. The Save As dialog box opens.In the Save As dialog box, specify the following options:In the address box, type the URL to a SharePoint document library. The URL resembles http://<server name>/<SharePoint site name>/< document library>.In the File name box, type a name for the Excel workbook.Click Save to publish the workbook.5. Use Excel Web Access web parts to display the named item(s) that you have defined on one or more SharePoint sites. For information about how to do this, see Display a workbook in an Excel Web Access Web Part