After you publish a workbook to Excel Services, you can make changes to it in Microsoft Office Excel at any time. Excel displays the entire workbook, even when you show only parts of it in Microsoft Office Excel Web Access. If needed, you can change the parts that you want to be viewable, and you can also add, change, or remove parameters to specify cells that are editable in the viewable worksheet data. When you save the workbook, the changes are automatically reflected on the server.

If you no longer need to present the workbook on Excel Services, you can delete it from the SharePoint document library.What do you want to do?

Edit a workbook that is published to Office SharePoint Server Excel Services

  1. To open the workbook that is published to Excel Services, do one of the following:
    • To open the workbook by using Excel, do the following:
      1. Click the Microsoft Office Button button image, and then click Open.
      2. In the File name box, type the URL of the server and the path to the workbook that you want to open.

        Tip For example, type http://server/site/file name

      3. Click Open.
    • To open the workbook by using the browser, do the following:
      1. In the Address box of the browser, type the URL of the server.

        Tip For example, type http://server/site

      2. Open the document library that contains the workbook.
      3. Click the down arrow next to the workbook that you want to open, and then click Edit in Microsoft Office Excel on the drop-down menu.
  2. Edit the workbook to incorporate any changes that you want to make.
  3. If you plan to define parameters, name the cells that you want to make 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 that contain more than one cell.

    To name cells, do the following:

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

      excel ribbon image

    3. In the Name box, type the name that you want to use for the parameter.
    4. Click OK.
  4. Click Microsoft Office Button button image, click Publish, and then click Excel Services.
  5. Click Excel Services Options.
  6. On the Show tab, do the following to change what parts of the workbook you want to show:
    • 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 of the sheets that you do not want to make viewable.

      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 PivotTable) 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, on the Parameters tab, click Add, select the check box of the parameter that you want to add, and then click OK.
  8. Click Save.

Delete a workbook from SharePoint Server Excel Services

To delete a workbook from Excel Services, do one of the following:

See also: