The Excel Team Blog : Excel 2010, Excel Server, Overview

Management Features of PowerPivot for SharePoint

Microsoft Excel 2010 — Mon, 01 Feb 2010 22:24:00 GMT

Thanks to John Hancock from the PowerPivot team for putting together this post. Previous articles have covered some of the features of PowerPivot for Excel, and shown how PowerPivot helps users build really powerful BI applications right in Excel. We have described some of the PowerPivot for SharePoint features on this blog as well as the PowerPivot blog , so for this article I will be focusing on the features that we provide to help IT to manage and understand the self-service BI activity. Self...(read more)

Editing in Excel Web App – Part II

Microsoft Excel 2010 — Tue, 19 Jan 2010 03:11:00 GMT

Today I’m going to continue on with our baseball stats tracking workbook example and talk more about the editing capabilities in Excel Web App. If you haven’t read Editing in Excel Web App – Part I though, I suggest you check it out first. Working with your data So now you’ve got a great looking workbook with lots of data and formulas. You send it out to your team and are sure that everyone will love it, and they do…sort of. Your team is picky. They want to “analyze” the data. The want to easily...(read more)

Excel Web App 2010 Overview

Microsoft Excel 2010 — Tue, 12 Jan 2010 04:47:00 GMT

Thanks to Steve Tullis for putting this together. Way back in November 2009, I wrote a short blog post announcing the two browser-based solutions the Excel team is delivering as part of the Office 2010 wave of products: Excel Services: Version two of our real-time, interactive, Excel-based reporting and dashboard capabilities which ship as part of SharePoint Server 2010. Also included are APIs which enable rich business application development. Excel Web App: The companion to the Excel client which...(read more)

Introducing the JavaScript Object Model for Excel Services in SharePoint 2010

Microsoft Excel — Tue, 01 Dec 2009 05:16:00 GMT

Thanks to Christian Stich , a consultant working on Excel Services projects, for putting together this series on the Excel Services JavaScript Object Model. Excel Services 2010 has added two entirely new programming APIs: The REST API which I covered in an earlier series of posts and the JavaScript Object Model (JSOM) which I will discuss in this post. The JavaScript Object Model (JSOM) enables a whole new set of solutions using Excel Services. With the JSOM it is possible to detect and react to...(read more)

Uncovering Publish to Excel Services in Excel 2010

Microsoft Excel — Tue, 24 Nov 2009 05:50:00 GMT

Thanks to Amy Lin for putting together this post. In Excel 2007, we introduced the ability to publish workbooks to SharePoint. This feature enabled users to upload Excel workbooks (or specific workbook items) on to their SharePoint sites for people to view and interact with using Excel Services. In Excel 2010, this feature has all the same functionality but the entry point has changed. For the Technical Preview/Beta users, the entry point will look different since these changes will be reflected...(read more)

Excel Services in SharePoint 2010 Feature Support

Microsoft Excel — Thu, 19 Nov 2009 17:00:00 GMT

Excel Services does a good job of rendering Excel spreadsheets with a high degree of fidelity. In other words, what you see in Excel is what you will see in Excel Services. Excel, however, is incredibly feature rich, comprising features added over decades of development. By comparison, Excel Services is a young product, so naturally Excel Services doesn’t yet support all the things you might create in Excel. So what does Excel Services in SharePoint 2010 support? And how does Excel Services deal...(read more)

Excel Services in SharePoint 2010 Administration Improvements

Microsoft Excel — Tue, 17 Nov 2009 05:37:00 GMT

Thanks to John Campbell for putting together this post. Ongoing management is key to any successful server product’s deployment. It can be challenging to figure out the right initial combination of settings, and to know how to further change those settings when problems arise. With that in mind, I have put this blog article together to go into what’s new in the Excel Services administration space. First Things First: SharePoint Administration and Service Applications Excel Services is a “Service...(read more)

Excel Services in SharePoint 2010 Dashboard Improvements

Microsoft Excel — Thu, 12 Nov 2009 03:34:00 GMT

Thanks to Dan Parish for putting together this post. One of the great things about Excel Services is the Excel Web Access (EWA) web part. This web part allows you to render entire workbooks, or just portions of a workbook (for example a chart or a Table) in a SharePoint dashboard page. For a high level overview of what you can do with the EWA in SharePoint 2007, take a look at some of our existing blog entries: Excel Services – Key Scenarios Excel services Part 5: All About “Interactivity” Excel...(read more)

Excel Services in SharePoint 2010 REST API Syntax

Microsoft Excel — Fri, 06 Nov 2009 05:08:00 GMT

As we saw in the previous post , using the Excel Services REST API is as simple as specifying a URI (Uniform Resource Identifier) in your web browser. In this post we’ll walk through the details of the URI syntax. We start out with a simple Excel workbook stored on a SharePoint 2010 server at the following URL: http://contoso/Finance/Shared%20Documents/Tax.xlsx This example workbook contains two named ranges, a chart, a table and a PivotTable. In order to create a URI that can be used to access the...(read more)

Simple Access to Spreadsheet Data Using the Excel Services 2010 REST API

Microsoft Excel — Thu, 05 Nov 2009 05:43:00 GMT

Thanks to Christian Stich for putting together this series on the REST API. Beginning our journey on all things Excel Services 2010, I thought I’d start off with a feature that’s been getting a lot of buzz lately since its introduction at the SharePoint Conference. What is it? The Excel Services 2010 REST API is a new programmability framework that allows for easy discovery of and access to data and objects within a spreadsheet. “Programmability” is almost a bit of a misnomer because in its simplest...(read more)

Excel Services 2010 Overview

Microsoft Excel — Wed, 04 Nov 2009 02:30:00 GMT

Thanks to Steve Tullis for putting together this post. Before delving into Excel Services 2010, I want to recap a point that some readers may not be aware of. The Excel team is delivering two browser-based solutions as part of the Office 2010 wave of products. The quick synopsis - here are the two solutions: Excel Services: Version two of our real-time, interactive, Excel-based reporting and dashboard capabilities which ship as part of SharePoint Server 2010. Also included are APIs which enable rich...(read more)

PowerPivot for SharePoint 2010 – The Business User’s Perspective

Microsoft Excel — Thu, 29 Oct 2009 07:03:00 GMT

This article continues the series on PowerPivot that started with an overview as well as an introduction to PowerPivot for Excel 2010. We’ll now focus on the support PowerPivot provides for collaboration. Frequently, business users need to share applications they create on their desktops with a workgroup. As it turns out, SharePoint provides a great platform that is critical for realizing the overarching goal of extending business intelligence technology to an organization: Great feature set for...(read more)

All About SharePoint 2010

Microsoft Excel — Tue, 20 Oct 2009 02:58:00 GMT

The SharePoint blog has a pretty extensive write up detailing the innovations in SharePoint 2010 . Here are some Excel relevant excerpts: On Business Intelligence: Historically, business intelligence has been a specialized toolset used by a small set of users with little ad-hoc interactivity. Our approach is to unlock data and enable collaboration on the analysis to help everyone in the organization get richer insights. Excel Services is one of the popular features of SharePoint 2007 as people like...(read more)