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 .. more »

Today is an exciting day! At PDC we announced the availability of the public betas of Microsoft Office 2010, SharePoint Server 2010, Visio 2010, Project 2010 and Office Web Apps for business customers. If youd like to be one of the millions of people who try, test and give feedback on the latest and greatest, you can download the betas at We also .. more »

Following on the heels of the Office 2010 beta availability announcement, the Office Web Apps blog has a new post discussing deploying office web apps in the enterprise.  Have a read if you're looking to test drive the beta version of Office Web Apps... more »

Todays author is Jan Karel Pieterse, an Excel MVP. You can find more useful tips from Jan Karel on his website: . This post informs you about Name Manager, a free utility that helps you manage defined names in your workbooks. If you need a free utility to manage defined names in your workbooks, this one is a must-have. List all names in your active .. more »

Ongoing management is key to any successful server products 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 whats new in the Excel Services administration space. First .. more »

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 .. more »

One of our most senior developers on Excel Services, Shahar Prish, is busy writing posts in his on the new programmability features in the 2010 version of Excel Services. The first set of posts talk about REST and moving forward he will expand to the new JavaScript OM we added this release. Here are the links, if you care at all about building .. more »

In this final installment on the REST API, well walk through a couple examples of using the REST API to embed spreadsheet data in new and interesting ways. Embedding a Live Chart on a SharePoint Wiki Page. For this example we are embedding an Excel scatter chart on a SharePoint wiki page. The scatter chart works like an analog clock, so that you .. more »

the range A1:D4 is entered as A1|D4 The Excel Services REST API provides a means to change values in the workbook. These changes only affect the values, HTML rendering info or charts returned by the REST API for that particular request. These changes are NOT saved back to the workbook, nor do they affect other REST API or Excel Web Access browser .. more »

Thanks to Christian Stich for putting together this series on the REST API. Beginning our journey on all things Excel Services 2010, I thought Id start off with a feature thats been getting a lot of buzz lately since its introduction at the SharePoint Conference. API is a new programmability framework that allows for easy discovery of and access to .. more »

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: Version two of our real-time, interactive, Excel-based reporting and dashboard capabilities .. more »

In Excel 2007, the ability to directly resize or reposition points on the chart was deprecated. This feature was sometimes referred to as "Graphical Goal Seek." For example, in Excel 2003 a user could click on a data point in a column chart twice which would surface handles that could be used to resize the columns. Over the last couple of years we .. more »

This article continues the series on to PowerPivot for Excel 2010. Well 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 .. more »

In this blog article, well step through using PowerPivot for Excel 2010 for building a rich application in Excel. , Gemini will be released under the PowerPivot brand. After installation, Gemini appears on the Excel 2010 ribbon: Selecting the Load & Prepare Data button launches the PowerPivot client window: As you would expect from any modern tool, .. more »

More info and a fun video here: http://powerpivot.com/.. more »

Today at the SharePoint conference the Office Developer Marketing Team announced the .  Here's an excerpt from his post: With the great value Office 2010 brings for end users, IT Professionals and Developers, we are also investing heavily in making deployment of the new version of Office easier. As part of our focus on deployment, we have renewed pr.. more »

I know many Excel users also tend to be Access users, so I thought it would be a good idea to share this bit of news.  The Access folks recently recorded a great video showcasing the major work that has gone into Access 2010.  In short: Access solutions, built in Access and published to the web where users interact with forms and reports via the br.. more »

Steve Tullis & Pej Javaheri presented “Intro to Excel and Excel Services 2010” to a standing room only crowd at SharePoint Conference 2010. Features demo’d include: Excel: Pivot Chart improvements Filter Search Named sets Improvements to conditional formatting Slicers Sparklines Excel Services: Client fidelity improvements & support of new Excel.. more »

About a month ago I wrote about the on Windows Live. Since then weve seen a lot of interest in Office Web Apps and received numerous requests from people wanting to try them out. To make this possible, we are opening up the Technical Preview and inviting more people to try out the Office Web Apps. For a limited time, you can sign-up for a Technical .. more »

More dispatches from Charlie Ellis at SPC.  Note, he mentions some new features we haven't yet talked about on the blog (spoilers!) but will soon! Three things really struck me during the keynote address: There’s just incredible momentum around SharePoint and a ton of excitement around SharePoint 2010 and all the great new social networking fun.. more »