Export (0) Print
Expand All

How to: Save from Excel Client to the Server

This example shows you how to:

  1. Create a workbook with editable ranges.

  2. Save the workbook to a SharePoint document library that is a trusted location.

    NoteNote:

    It is assumed that you have already created a SharePoint document library and made it a trusted location. For more information about this, see How to: Trust a Location and How to: Trust Workbook Locations Using Script.

  3. Change values in a workbook by using the parameters pane in Excel Web Access.

Saving a Workbook to Excel Services

To create a workbook with editable ranges

  1. Start Microsoft Office Excel 2007.

  2. In cell A1, type 8.

  3. In cell A2, type =3*A1.

  4. To make cell A1 editable in Excel Web Access, you must first make cell A1 into a named range. First click the Formulas tab. Then click cell A1 to select it. On the Formulas tab, in the Named Cells group, click Name a Range. In the New Name dialog box, in the Name box, type MyAOneParam.

  5. Save the workbook to a location of your choice on the local drive. Name the workbook "TestParam.xlsx".

To save to Excel Services

  1. Click the Microsoft Office Button, point to Publish, and then click Excel Services.

  2. In the Save As dialog box, click Excel Services Options.

  3. In the Excel Services Options dialog box, on the Show tab, make sure that Entire Workbook is selected.

  4. Click the Parameters tab.

  5. Click Add.

  6. In the Add Parameters list, select the MyAOneParam check box.

  7. Click OK. You should now see "MyAOneParam" in the Parameters list.

  8. Click OK to close the Excel Services Options dialog box.

  9. In the Save As dialog box, make sure that the Open this workbook in my browser after I save check box is selected.

  10. In the File name box, type the path to the trusted SharePoint document library where you want to store this workbook. For example, http://MyServer002/MyDocumentLibrary/TestParam.xlsx.

  11. Click Save. You should see TestParam.xlsx in Excel Web Access.

To change values using parameters

  1. In the Parameters pane, you should see the named range for cell A1—that is, "MyAOneParam".

  2. You can change the values in cells A1 and A2 by typing a number in the box next to "MyAOneParam". For example, if you type 10 and then click Apply, cell A1 will change to "10" and cell A2 to "30".

See Also

Community Additions

ADD
Show:
© 2015 Microsoft