In Microsoft Excel 2010, you can publish a workbook to a Microsoft SharePoint Services 2010 site so that other users can view its data in a web browser without having Excel installed on their computers. In addition, by setting some publish options, you can emphasize specific parts of your workbook in the browser. A great way to utilize this feature is by displaying an Excel chart on a SharePoint page to help your organization make agile business decisions.
This article shows you how to publish a workbook from the Excel 2010 desktop program, and does not cover connecting a workbook or workbook data to an Excel Web Access web part on a SharePoint page.
When you publish a workbook to a SharePoint server, the entire contents of the workbook are saved to the server and can be viewed and worked with if you open the workbook in the Excel desktop program. If Office Web Apps are deployed on the SharePoint server, viewing and working with your data in the web browser can be very much like working with your data in the Excel desktop program. In fact, simultaneous editing of a workbook is possible in the browser grid when Office Web Apps are deployed. When you view a workbook in the browser, if the Edit in Browser button is visible, this means that Office Web Apps are available.
PREPARE THE WORKBOOK
Before you publish the workbook, you have the opportunity (in the Publish Options dialog box) to select the worksheets or items that you want visible in the browser when editing has not been enabled by clicking the Edit in Browser button. Just remember that although you can select what is viewable in this mode, the entire contents of the workbook are still saved to the SharePoint server.
If you want to include entire worksheets as an item in addition to other items, such as charts or PivotTables, define the entire worksheet as a named range. Select the entire worksheet, and then define a named range. This named range will then appear as an available item in the Publish Options dialog box when you are ready to publish.
If you want to allow users to provide a parameter to a formula when viewing a worksheet in a browser, set a cell as a defined name. You can then add that defined name as a parameter on the Parameters tab in the Publish Options dialog box.
PUBLISH THE WORKBOOK
- Save & Send.
- Save to SharePoint.
Note : If the Save to SharePoint command is unavailable, you can still save the workbook to a SharePoint site by using the Save As command. The Publish Options dialog box will not be available. You can also directly upload the workbook from a SharePoint library. Users can view and edit the contents of the workbook in the browser by going directly to the site where the workbook is saved.
- If you want to select individual worksheets or items to publish in the workbook, click the Publish Options button. Otherwise, if you want to publish the entire workbook, skip directly to step 4.
On the Show tab, do the following:
- To show the entire workbook in the browser, select Entire Workbook in the list box.
- To show only specific worksheets in the browser, 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 in the browser (such as named ranges, charts, tables, or PivotTables), select Items in the Workbook in the list box, and then select the check boxes of the items that you want to show.
Note: If you select items that have the same name (such as a chart and its underlying table of data), only one of these items will be available in the browser. To show all the items, you must make sure that each item in the workbook has a unique name. You can rename tables on the Design tab in the Properties group, rename PivotTables on the Options tab in the Pivot Table group, and rename charts or PivotCharts on the Layout tab in the Properties group. Duplicate items, such as named ranges, can be renamed on them Formulas tab in the Defined Names group.
- On the Parameters tab, add any defined names that you want to use to specify cells that are editable when users view the workbook in the browser. Then click OK to close the dialog box.