November 2005 - Posts
One thing that we hear from customers is that they would like to be able to re-use Excel spreadsheets in web portals and dashboards simply and without needing to write a bunch of custom code. For example, they have business people (financial analysts,
Read More...
In the past few posts I have talked about all the work we have done to make managing, sharing, and securing your Excel workbooks better using SharePoint and Excel Services. Today, I am going to cover a new feature that provides management, sharing, and
Read More...
Yesterday I discussed one of the main security mechanisms for spreadsheets saved to SharePoint - the View Item right - that guarantees users will only be able to view a spreadsheet on the server and not download it to the client. Today I will cover how
Read More...
To this point in my discussion of Excel Services, I have written primarily about the user-facing part of Excel Services - all the things customers can do with Excel Web Access and Excel Web Services in order to execute and interact with workbooks on the
Read More...
Last week I gave an overview of Excel Web Services and the types of scenarios these web services will enable. This post, I would like to show you an example. Let’s look at implementing a browser-based mortgage calculator. The application is simple, but
Read More...
Today I decided to take a quick break from Excel Services to talk about a few small but useful changes that have been made to the status bar and show off a few charts First, the status bar Zoom control - we have added a slider that allows the user to
Read More...
While talking about scenarios for Excel Services, I mentioned “Reusing the logic encapsulated in Excel spreadsheets in custom applications” – which means accessing spreadsheets and their contents server-side via web services in a way that’s scalable and
Read More...
Now that I have discussed publishing spreadsheets to Excel Services, let’s review how users can “interact” with spreadsheets that Excel Services has generated. To start, I want to explain what we mean by “interact” because it is anther development-team
Read More...
Now that I have spent some time talking about goals and architecture, I want to spend some time talking about the features provided by Excel Services, starting with how you get a spreadsheet on a server in the first place. There are two ways to get a
Read More...
Before I continue to drill down on the features of Excel Services, I would like to explain the architecture at a high level and touch on configuration possibilities. Excel Services is built on the SharePoint products and technologies platform. There are
Read More...
We targeted three scenarios for this initial release of the product (note – “scenario” is development-team speak for “what we expect customers will want to do with a set of features in a product”). Sharing spreadsheets through the browser Building business
Read More...
Back in September, I posted an article on the big picture which mentioned that we are creating an all-new “Excel Services” server technology as part of our Excel 12 work. Some of you may have caught a glimpse of Excel Services being demonstrated as part
Read More...
If you’ve been reading the last few posts on tables, you may have noticed that the screenshots all had tables with formatting applied to the entire table. You may have thought I spent lots of time manually formatting the tables to look nice for this blog
Read More...
Being able to remove duplicate rows of information from a table of data is a request we hear fairly often from our customers (and one of the top questions in the comments in this blog). Some users know that this capability exists in Excel today; unfortunately
Read More...
One of the things I mentioned in my overview of Excel 12 post in September was that we had done some work to speed up calculation on modern hardware (multi-processor or dual-core chips). I thought I would take a brief break from tables to summarize that
Read More...
I mentioned in my previous post that the three-condition limit on sorting (Data|Sort) has been removed in Excel 12. As someone correctly pointed out in a comment many posts ago, this means the current sort dialog has changed in Excel 12. Here’s what the
Read More...
Sorting and filtering are two of the most important types of basic analysis that you can do with data. In Excel 12, we have improved sort and filter functionality to better expose common tasks, to make key tasks simple, and to enable scenarios that were
Read More...
