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

Browse by Tags

  • Excel Services content refresh is live

    If you're a developer, you may have been wondering..."When are they EVER going to revise the Excel Services JavaScript Object Model (JSOM) documentation for SharePoint Server 2010?" Well, I'm glad you asked! The SharePoint Server 2010 Software Development Kit (SDK) online documentation has been refreshed, and I'm happy to announce that as part of that refresh, the Excel Services JSOM documentation was also updated--in fact, it's been completely revised. Keep reading to learn...
  • Embedding Excel Web App in your own web page or blog

    Today’s blog post is brought to you by Dan Parish a Program Manager on the Excel Web App team. One of the feature requests we frequently get for Excel Web App is “it would be great if there was a way to embed my workbook in my blog”. Well, starting today, if you have an Excel workbook (xlsx or xlsb only) or a PowerPoint presentation on SkyDrive, you can embed them! In fact, the following embedded PowerPoint presentation will show you how: There is also a help article (referenced...
  • More about collaborative editing in Excel Web App

    Thanks to Dan Parish for writing this blog post. In today’s post, I’m going to delve into some of the finer details of collaboration using Excel Web App. If you haven’t already read Collaborative Editing Using Excel Web App however, please start there. It goes over what is supported, how it works, our presence UI, as well as some interesting collaborative scenarios that this feature opens up. Today’s post is really a “Part II” to that post. Multiple Browser Windows Excel Web App allows you to collaborate...
  • Management Features of PowerPivot for SharePoint

    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...
  • 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...
  • 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...
  • 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...
  • 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...
  • Introducing the JavaScript Object Model for Excel Services in SharePoint 2010

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