Moss 2007 Excel Services Setup & Publishing Excel Workbook On Sharepoint

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: [email protected]

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

6

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

7 9 10 10 10 11 12 13

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

14 14 15 17

END-MOD.23

17

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

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

www.globalopenversity.org

ICT103 - MOSS 2007 Win2k3 Active Directory Exchange2k3 SS0 Integration

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: [email protected]

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.

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

www.globalopenversity.org

ICT103 - MOSS 2007 Win2k3 Active Directory Exchange2k3 SS0 Integration

2

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

Settings, then under the Site libraries and lists

3. Select Site

Administration

section select Site

Fig. 23.2

4. Follow the link below to access the full document.

The full document has moved to Docstoc.com. You can access and download it from here: http://www.docstoc.com/docs/31001838/?key=MjY3ODYyYmQt&pass=YWVmZi00YzBi

----------------------------------------------Kefa Rabah is the Founder and CIO, of Global Technology Solutions Institute. Kefa is highly knowledgeable in several fields of Science & Technology, IT Security Compliance and Project Management, and Renewable Energy Systems. He is also the founder of Global Open Versity, a Center of Excellence in eLearning.

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

www.globalopenversity.org

ICT103 - MOSS 2007 Win2k3 Active Directory Exchange2k3 SS0 Integration

3