Saturday, January 12, 2013

What are the steps to Publish Excel Workbook to sharepoint?


Connect the Web Parts by using a document URL
1.    Add the List View Web Part of the document library and the Excel Web Access Web Part to a Web Part Page. For more information, see List View Web Part and Add or remove a Web Part.
2.    On the Site Actions menu  , click Edit Page.
3.    From the Excel Web Access Web Part, click the Web Part menu  , point to Connections, point to Get Workbook URL From, and then click the appropriate List View Web Part.
4.    In the Configure Connection dialog box, select Document URL from the Field Name list box, and then click Finish.
5.    To exit Web Part Page Edit Mode and view the page, at the top of the Web Part Page, under the Site Actions  drop-down menu, click Exit Edit Mode.
6.    To view each workbook in the Excel Web Access Web Part, click the option button next to the workbook item in the List View Web Part.
Connect the Web Parts by using a named item
1.    Add the List View Web Part of the list that contains the named items and the Excel Web Access Web Part to a Web Part Page. For more information, see List View Web Part and Add or remove a Web Part.
2.    On the Site Actions menu  , click Edit Page.
3.    On the opening screen of Excel Web Access, click the link, Click here to open the tool pane.
The Web Part enters Edit Mode and the Web Part Tool Pane is displayed.
4.    Enter the URL or UNC of the workbook that contains the named items in the Workbook text box.
To easily locate a workbook, click Select a Link  and use the Select a Link dialog box.
5.    From the Excel Web Access Web Part, click the Web Part menu  , point to Connections, point to Get Named Item From, and then click the appropriate List View Web Part.
6.    In the Configure Connection dialog box, select Title from the Field Name list box, and then click Finish.
7.    To exit Web Part Page Edit Mode and view the page, at the top of the Web Part Page, under the Site Actions  drop-down menu, click Exit Edit Mode.
8.    To view each named item in the Excel Web Access Web Part, click the option button next to the named item in the List View Web Part.

No comments:

Post a Comment