How to publish a workbook to excel service

[Chandranath]

I am looking for some tips on publishing the Microsoft Excel document. I have a work book. It is possible to publish the workbook on the sharepoint server. But I had not done this before. What all is needed to do here. Does the workbooks needs an html format to get live on the sharepoint server. What all are the necessity.

[JonathanD]

If you have access to Excel Services, which is a server running Microsoft Office SharePoint Server 2007 that is competent of running Excel Calculation Services, you can publish a workbook to that server so that other users can have a right to entry all or parts of the data that it includes in a 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 entrenched in Web pages.) by using Microsoft Office Excel Web Access.

[Macarenas]

By demonstrating only precise parts of the workbook and by using Office SharePoint Server 2007 authorizations to help protect the workbook from unauthorized access, you can keep data in the workbook endorsement while enabling authorized users to refresh, recalculate, and interact with the viewable data. .When you publish a workbook to Excel Services, the complete workbook is published on the server, but you can characterize the parts of the workbook (such as individual worksheets, named ranges, or charts) that you want Excel Services to demonstrate in Office Excel Web Access.

[ThoMas321]

You can also describe parameters. Parameters are single cells that can have their values distinct by Office Excel Web admittance users. You can use parameters to representation 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. Not all Microsoft Office Excel characteristics are supported by Excel Services. For information about unsupported characteristics, see Excel characteristics that are not supported by Excel Services.

[ZeDaX]

To distribute a workbook to excel service. You have to generate a new workbook and get into the data that you desire to present, or open an existing workbook that you desire to distribute to Excel Services. If you plan to define restrictions, name the cells that you desire to be editable. You can define restrictions only if you have named single cells that contain values on the worksheet. You cannot define restrictions for named ranges of more than one cell.

[Sam.D]

If you want to name the cells, do the following: On the worksheet, select the cell that you desire to make editable in the browser and Office Excel Web Access. In the Name box, type the name that you want to use for the restriction. Click OK. Click Microsoft Office Button , click the arrow next to Publish, and then click Excel Services under Distribute the document to other people. 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 objective in the Save in list, or type the path to the server before the file name.