EXCEL SERVICES

Excel Services is a Microsoft Office SharePoint technology that makes it simple to use, share, secure, and manage Microsoft Office Excel 2007 workbooks (.xslx, xslb) as interactive reports in a consistent way throughout the enterprise.

 

Setting up and Publishing to Excel Services Step By Step
Walking you through the process of configuring Excel Services in MOSS 2007. This will walk you through the steps from configuring your server all the way through publishing and displaying an Excel workbook in the Excel Web Access web part.

• visit blog - Setting up and Publishing to Excel Services Step By Step

Developing User-Defined Functions for Excel 2007 and Excel Services
Learn to develop and reuse user-defined functions (UDFs) for use in Excel 2007 and Excel Services in SharePoint Server 2007.

• visit Developing User-Defined Functions

 

Excel Services Blogs

• Starting Excel Services and setup.
  MOSS 2007 Excel Services - Imran Agha's blog
• Simple Excel Services - Step by step, publishing a spreadsheet to SharePoint 2007 - Tobias Zimmergren blog
  Describes how you can connect your excel spreadsheet to a SharePoint list using Excel Services.This will simply step you through the process of creating a spreadsheet and publish it in a document library and be able to open it in your browser.

 

Downloads

• Sample: Extending the Excel Services Programmability Framework
• Sample: User-Defined Functions for Excel 2007 and Excel Services Sample Solution
• Sample: Web Part That Calls Excel Web Services
• SDK: SharePoint Server 2007 SDK and Enterprise Content Management Starter Kit

Technical Articles

• Data Type Handling with Excel Services User-Defined Functions
• Deploying and Optimizing a SharePoint Web Part That Calls Excel Web Services
• Excel Services Technical Overview
• Using Excel Web Services in a SharePoint Web Part

Visual How-To's

• Creating Managed-Code UDFs for Excel Services
  Much like previous versions of Microsoft Office Excel, Microsoft Office Excel 2007 provides support for user-defined functions (UDFs). UDFs are custom functions that extend the calculation and data-import capabilities of Excel 2007.
• Retrieving Excel 2007 Workbooks or Snapshots Using Office SharePoint Server 2007 Excel Services
  If you want to save a copy of an up-to-date workbook, store it somewhere, send it to someone, and so on, you can retrieve an entire workbook or a snapshot using Excel Web Services. When a user or application requests a snapshot, Excel Services opens the Excel file on the server, refreshes data sources, and calculates all Excel formulas. Excel Services then generates and sends a snapshot back through the Web service API.

Videos | Screencasts

• Demo: Enable Excel Services and Data Connections for a SharePoint Team Site
• Building Custom Solutions with Excel Services
• Getting Up and Running with Excel Services
• Business Intelligence in Excel 2007
• More Business Intelligence in Office 2007

 

MSDN Webcasts

• Using Grid Computing to Scale Excel Services (Level 200)
  

 

Blogs and Newsgroups

• Excel Services Category on the Excel 2007 Blog
• Excel 2007 Blog
• LuisBE on Services
• Shahar Prish Blog
• Sherman on Excel and BI Technology

Forums

• Excel Services Forum
• SharePoint Products and Technologies Forum

Business Intelligence with Office SharePoint Server 2007

• Microsoft Office Excel-based Business Intelligence
• Plan Key Performance Indicators (Plan for Business Intelligence)

Resources on Office Online

• Connect a List View Web Part to Excel Web Access
• Excel Services Datasheet
• Excel Services Overview White Papers
• Excel Web Access Web Part Summary
• Introduction to Excel Services and Excel Web Access
• Microsoft Office Excel Services Business Value
• Print a View, Named Item, or Workbook from Excel Services
• Refresh External Data in Excel Services
• Roadmap for Publishing an Excel Workbook as "One Version of the Truth"

Resources on TechNet

• Add a Trusted Data Connection Library
• Determine Resource Requirements to Support Excel Services
• Plan Access to Excel Spreadsheets
• Plan Data Connection Management
• Plan Excel Services Security
• Plan External Data Connections for Excel Services