Display an Excel workbook in Excel Web Access

To view and interact with a Microsoft Office Excel workbook in Microsoft Office Excel Web Access, enter the workbook URL or UNC in the Microsoft Office Excel Web Access Web Part Workbook property.

Note: The workbook author should save the workbook from Microsoft Office Excel 2007 to a Microsoft Windows SharePoint Services document library or network folder by clicking the Microsoft Office Button Office button image , clicking Publish, and then by clicking Excel Services.

  1. If necessary, create a Web Part Page and add the Excel Web Access Web Part.

    For more information about creating Web Part Pages and adding Web Parts, see Microsoft Office SharePoint Server Help and Windows SharePoint Services Help.

  2. In the opening instructions, click the link Click here to open the tool pane.

    The Web Part Page and Web Part enter Edit Mode and the Web Part Tool Pane is displayed.

  3. Enter the URL or UNC of the workbook in the Workbook text box.

    To easily locate a workbook, click Select a Link Builder button and use the Select a Link -- Web Page Dialog window.

  4. To save changes and exit Web Part Edit Mode, at the bottom of the Web Part Tool Pane, click OK.

  5. To exit Web Part Page Edit Mode and view the workbook in Excel Web Access in Web Part Page Display mode, at the top of the Web Part Page, under the Site Actions drop-down menu, click Exit Edit Mode.

Note: Alternatively, you can connect a List View Web Part of a document library to the Excel Web Access Web Part and then pass the URL of the workbook that is stored in the document library to the Excel Web Access Web Part.

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.