Edit or remove a workbook from Excel Services

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.

Important: The ability to publish an Excel workbook to Excel Services is available only in Microsoft Office Ultimate 2007, Microsoft Office Professional Plus 2007, Microsoft Office Enterprise 2007, and Microsoft Office Excel 2007.

What do you want to do?

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

Delete a workbook from SharePoint Server Excel Services

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

      The Defined Names group on the Formulas tab

    3. In the Name box, type the name that you want to use for the parameter.

    4. Click OK.

  4. Click Microsoft Office Button Office 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:

    1. To show the entire workbook in Excel Services, select Entire Workbook in the list box.

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

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

Top of Page

Delete a workbook from SharePoint Server Excel Services

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

  • To delete the workbook from the server by using Excel, do the following:

    1. Click the Microsoft Office Button Office button image , and then click Open.

      Keyboard shortcut  To display the Open dialog box, press CTRL+O.

    2. Click My Network Places, and then double-click the server to which you saved the workbook.

    3. Double-click the document library that contains the workbook.

    4. Click the workbook that you want to delete, and then click Delete delete .

      Keyboard shortcut  You can also click the file that you want to delete, and then press DELETE.

  • To delete the workbook from the server 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 Delete on the drop-down menu.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×