If you have access to Excel Services, which is a server running Microsoft Office SharePoint Server that is capable of running Excel Calculation Services, you can publish a workbook to that server so that other users can access all or parts of the data that it contains in a browser by using Microsoft Office Excel Web Access.

When you publish a workbook to Excel Services, the entire workbook is published on the server, but you can define the parts of the workbook (such as individual worksheets, named ranges, or charts) that you want Excel Services to display in Office Excel Web Access. By displaying only specific parts of the workbook and by using Office SharePoint Server permissions to help protect the workbook from unauthorized access, you can keep data in the workbook confidential while enabling authorized users to refresh, recalculate, and interact with the viewable data.

You can also define parameters. Parameters are single cells that can have their values defined by Office Excel Web Access users. You can use parameters to expose cells that can drive workbook calculation, such as a what-if analysis that is using the values that users enter in cells that are specified as parameters.

Note Not all Microsoft Office Excel features are supported by Excel Services. For information about unsupported features, see .

  1. Create a new workbook and enter the data that you want to provide, or open an existing workbook that you want to publish to Excel Services.
  2. If you plan to define parameters, name the cells that you want to be editable.

    Note You can define parameters only if you have named single cells that contain values on the worksheet. You cannot define parameters for named ranges of more than one cell.

    To name cells, do the following:

    1. On the worksheet, select the cell that you want to make editable in the browser and Office Excel Web Access.
    2. On the Formulas tab, in the Defined Names group, click Define Name.

      outlook ribbon image

    3. In the Name box, type the name that you want to use for the parameter.
    4. Click OK.
  3. Click Microsoft Office Button button image, click the arrow next to Publish, and then click Excel Services under Distribute the document to other people.
  4. In the File name box, enter the path to the server and accept the suggested name for the workbook, or type a new name if needed.

    Tip If needed, locate the destination in the Save in list, or type the path to the server before the file name. For example, type http://server/site/file name

    Note Excel can publish a workbook to the server only in the Microsoft Office Excel XML-based file format (.xlsx) or Office Excel Binary file format (.xlsb).

  5. Click Excel Services Options.
  6. On the Show tab, do the following:
    • To show the entire workbook in Excel Services, select Entire Workbook in the list box.
    • To show only specific worksheets in Excel Services, select Sheets in the list box, and then clear the check boxes for the sheets that you do not want to make visible.

      Note By default, all sheets are selected. To quickly make all sheets viewable again after you clear some of the check boxes, you can select the All Sheets check box.

    • To show only specific items (such as named ranges, charts, tables, or PivotTables) in Excel Services, select Items in the Workbook in the list box, and then select the check boxes of the items that you want to show.
  7. To define parameters, click the Parameters tab.

    Note You can define parameters only if you have named single cells that contain values on the worksheet. You cannot define parameters for named ranges that contain more than one cell.

  8. Click Add, and then select the check box of the parameter that you want to add.
  9. Click OK.
  10. Click Save.
  11. To verify that the viewable areas of the workbook are displayed correctly in the browser, select the Open this workbook in my browser after I save check box.

Notes:

See also: