Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

MOSS 2007 Excel Services Setup and Publishing Excel Workbook on SharePoint

VIEWS: 2,612 PAGES: 17

Introduction: Excel Services is a new technology that ships as part of Shared Services and allows you to calculate and display Excel spreadsheets using MOSS 2007 without necessarily having a copy of Excel on the client machines. With Excel Services you can simply share a spreadsheet using the browser. Excel Services has a calculation engine that supports calculating spreadsheets on the server in order to offload resource intensive calculations.

More Info
  • pg 1
									Module 23                                 MOSS 2007: Document Library, Excel Service and Trusted File Locations




    Module 23 - MOSS 2007 Excel Services Setup & Publishing Excel
                     Workbook on SharePoint
                            Kefa Rabah, Global Open Versity, Vancouver Canada
                                   Email: karabah@globalopenversity.org

Table of Contents                                                                                  Page No.

MODULE 23                                                                                                     2

MOSS 2007 EXCEL SERVICES SETUP & PUBLISHING EXCEL                                                             2

WORKBOOK ON SHAREPOINT                                                                                        2

23.1 Step 1 - Create Document Library                                                                         2

23.2 Step 2- Configuring Excel Service in MOSS 2007 – Sharing your Excel Workbooks                            5

23.3 Step 3 – Create Excel Services Trusted File Location                                                     6
  23.3.1 Configure Excel Services timeouts                                                                    8
  23.3.2 Configure MOSS Single-Sign-On (SSO)                                                                  9
     23.3.2.1 Introduction to single sign-on authentication                                                   9
     23.3.2.2 Start the Single Sign-On service                                                                9
     23.3.2.3 Managing single sign-on settings                                                               10
     23.3.2.4 Manage single sign-on settings                                                                 11
  23.3.3 Configure Excel Services’ Unified Logging Service                                                   12

23.4 Step 4 – Create and Publish a Workbook to Excel Services                                                13
  23.4.1 Create an Excel workbook (MyCompanySales.xlsx)                                                      13
  23.4.2 Publish the Workbook to Excel Services                                                              14
  23.4.3 Ensure users open the spreadsheet in the browser                                                    16

END-MOD.23                                                                                                   16

             A Global Open Versity (GOV) Academic Technical Publication
                         Permissions: GOV Open Knowledge Access License




© A GOV Open Knowledge Access Technical Academic Publications License
Enhancing education & empowering people worldwide through eLearning in the 21st Century

                                                                                                              1
© April 2007, Kefa Rabah, Global Open Versity, Vancouver Canada

www.globalopenversity.org         ICT103 - MOSS 2007 Win2k3 Active Directory Exchange2k3 SS0 Integration
Module 23                                 MOSS 2007: Document Library, Excel Service and Trusted File Locations




                                                Module 23

              MOSS 2007 Excel Services Setup & Publishing Excel
                         Workbook on SharePoint
                            Kefa Rabah, Global Open Versity, Vancouver Canada
                                   Email: karabah@globalopenversity.org

Introduction: Excel Services is a new technology that ships as part of Shared Services and allows you to calculate
and display Excel spreadsheets using MOSS 2007 without necessarily having a copy of Excel on the client machines.
With Excel Services you can simply share a spreadsheet using the browser. Excel Services has a calculation engine
that supports calculating spreadsheets on the server in order to offload resource intensive calculations.


23.1 Step 1 - Create Document Library
First of all, to apply this article you have to create a document library in your MOSS web application.
Before that, you have to create a web application if you haven’t done so yet.

From MOSS central administration you will select Application Management > Create or extend Web
Application, and follow the steps. After you finish creating the web application you can create a
document library as the following.

    1. Open your web application in the browser in our case we will use our SSP: SharedServices1:
       http://sharepoint:1111.




                                                                                                                2
© April 2007, Kefa Rabah, Global Open Versity, Vancouver Canada

www.globalopenversity.org         ICT103 - MOSS 2007 Win2k3 Active Directory Exchange2k3 SS0 Integration
Module 23                               MOSS 2007: Document Library, Excel Service and Trusted File Locations



    2. On the right side of the page you will find and click the Site Actions menu if you are the
       administrator on this site as shown below.




                                                          Fig. 23.1

    3. Select Site  Settings, then under the Site                 Administration       section select Site
        libraries and lists




                                 Fig. 23.2



    4. From Sites Libraries and List page select Create new content.




        Fig. 23.3

    5. Under Libraries select the Document Library.




                                                                                                            3
© April 2007, Kefa Rabah, Global Open Versity, Vancouver Canada

www.globalopenversity.org        ICT103 - MOSS 2007 Win2k3 Active Directory Exchange2k3 SS0 Integration
Module 23                               MOSS 2007: Document Library, Excel Service and Trusted File Locations




                      
								
To top