Show All

Hide All

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.

• 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 , 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 (browser: Software that interprets HTML files, formats them into Web pages, and displays them. A Web browser, such as Windows Internet Explorer, can follow hyperlinks, transfer files, and play sound or video files that are embedded in Web pages.), 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.

      

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

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

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

     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 (browser: Software that interprets HTML files, formats them into Web pages, and displays them. A Web browser, such as Windows Internet Explorer, can follow hyperlinks, transfer files, and play sound or video files that are embedded in Web pages.), 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