Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office SharePoint Server (MOSS)
Search
Search
 
Icon: Flag: (c) Microsoft
Get up to speed
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

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

advertisement