Back Forward Home Print Search
SharePoint Server 2007 Help and How-to >  Business intelligence >  Excel Services >  Basics
Display an Excel workbook in Excel Web Access
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 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 ButtonButton 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 Services 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 LinkButton image 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. For more information, see Connect a List View Web Part to Excel Web Access.