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

January 2010 - The Excel Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • Programmability Improvements in Excel 2010

    Thanks to Danny Khen for putting together this post. What’s new? Excel has been a platform for developing business solutions for a long time now. Developers write code to customize and extend Excel in many ways – automating Excel operations, user interface customizations, data entry forms and extending Excel formulas with user defined functions, to name some key ones. Many developers create very complex applications, which have demanding requirements and push Excel to its limits, so developers are...

  • Table Improvements in Excel 2010

    Thanks to Ben Rampson for putting together this post. In today’s article I will outline three features in Office 2010 that improve table interaction in Excel. These feature additions build on the work started Excel 2007, addressing areas with significant customer feedback and further improving the feature area. The first table improvement feature, AutoFilters in sheet headers, builds on work completed in the previous version of Excel. In Office 2007, when the table header of a selected table is scrolled...
    Filed under: , ,

  • Collaborative Editing Using Excel Web App

    In the last couple posts, we talked about how editing in Excel Web App works, how it’s different than editing in the Excel desktop client, and the kinds of things you can do in the Excel Web App. If you haven’t read about the editing experience yet, start with the Editing in Excel Web App – Part I post. Today I am going to cover how Excel Web App’s editing functionality enables easier collaboration on spreadsheets among multiple authors. Collaborative Editing – What’s That? Picture this scenario...
    Filed under: ,

  • Editing in Excel Web App – Part II

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

  • Editing in Excel Web App – Part I

    Thanks to Dan Parish for putting together this series on editing in Excel Web App. Before I get started, if you haven’t already read our Excel Web App 2010 Overview , you may want to take a minute to get acquainted with what Excel Web App is all about. In the next two posts I’m going to be talking about the editing capabilities of Excel Web App, and I’ll use the example of creating a simple baseball stats tracking workbook throughout so that you can see how all of these capabilities come together...
    Filed under: ,

  • Excel Web App 2010 Overview

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

  • Report statistics about a Set of Workbooks

    Today’s contributor is Sarah Hothersall, Liaison Director at Lyquidity. She’s providing information about the Workbook Statistics add-in, a free tool for Excel users that was created by Sandy Marshall, a Product Manager at Lyquidity, who is in charge of development of ComplyXL for enterprise spreadsheet management. To download this add-in, visit http://www.lyquidity.com/workbookstatistics . Sometimes it is helpful to report statistics about a set of workbooks contained in a folder. You can use this...
    Filed under:

  • Updated Excel Services Web Services API in SharePoint 2010

    Thanks to Christian Stich, the founder of Excel Services Consulting, L.L.C. , for putting together this post on the updated Excel Web Services API. The Excel Web Services API that initially shipped with Excel Services 2007 has been updated and expanded for Excel Services in SharePoint 2010. I will address the additions and changes for the Excel Web Services API for SharePoint 2010 in this post. Additional information about the Web Services API covering the 2007 implementation can be found in the...
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.