Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

November 2009 - The Excel Team Blog

The Excel Team Blog
  • Create conditional drop-down lists

    Today’s author is Reinout Dorreboom from the Netherlands, a Technical Consultant at Getronics, where he has worked with Office applications for many years, and where his Microsoft Certified Training skills enabled him to help other people get up to speed with Excel. In Excel 2007 (and earlier), it’s possible to create a drop-down list. By using the INDIRECT function, you can then create additional drop-down lists that are conditional to the first drop-down list. In this example we’ll create the following...
  • Uncovering Publish to Excel Services in Excel 2010

    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...
  • Excel Services in SharePoint 2010 Feature Support

    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...
  • Deploying Office Web Apps in the Enterprise

    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. Read More...
  • Announcing Office 2010 and PowerPivot Beta Availability

    From the Office 2010 Engineering blog : 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 you’d 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 www.microsoft.com/2010 . We also announced that Microsoft Office Mobile 2010 beta is available now too, and you can download...
  • Easily manage defined names in Microsoft Excel

    Today’s author is Jan Karel Pieterse, an Excel MVP. You can find more useful tips from Jan Karel on his website: http://www.jkp-ads.com/ . 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 workbook. Filter them using 13 filters including "With external references," "With errors," "Hidden...
  • Excel Services in SharePoint 2010 Administration Improvements

    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...
  • Find Combinations

    Today’s author is Bill Seddon from Lyquidity Solutions, who informs us about a free tool for Excel users that allows you to find combinations of numbers that total to a selected value. For more information and a video, see http://www.lyquidity.com/findcombinations . Imagine you are an auditor or cash accountant and need to reconcile cash balances to their invoices.  Which combination of values makes up each cash value?  Not surprisingly, the Find Combinations add-in has been popular with...
  • Excel Services in SharePoint 2010 Dashboard Improvements

    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...
  • New Posts From One of the Principal Developers Behind Excel Services

    One of our most senior developers on Excel Services, Shahar Prish, is busy writing posts in his blog 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 custom solutions for Excel and Excel Services they are a great read: General posts about REST: Welcome to the new Excel Services So what does REST on...
  • Excel Services in SharePoint 2010 REST API Examples

    Thanks to Christian Stich for putting together this series on the REST API. In this final installment on the REST API, we’ll 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 can see that the data returned via REST is dynamic, and the workbook containing...
  • Excel Services in SharePoint 2010 REST API Syntax

    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...
  • Simple Access to Spreadsheet Data Using the Excel Services 2010 REST API

    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...
  • Excel Services 2010 Overview

    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...
  • Excel Add-In for Manipulating Points on Charts (MPOC)

    Overview 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 have received a lot of feedback from customers indicating that this was a valuable feature for some scenarios. However, we were not...
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.