Today I wanted to talk about PivotTable context menus, for two reasons … first, because we have updated them to make them more useful, and second, because we have added some neat new features that are exposed primarily in context menus. All of this is part of our work to make PivotTables easier to explore and manipulate. Let’s take a look at some of the improvements and additions. Sorting by items on rows or columns Below is a screenshot of the context menu for an item on rows or columns (we have...

As I mentioned a few posts back, one of the key goals for PivotTables in Excel 12 was to use the Ribbon and new dialogs to expose PivotTables’ capabilities to a much broader range of users. Today I want to take a closer look at the new user interface – especially the ribbon – and how we have tried to make commonly-used features and functions much more visible and available with very few clicks of the mouse. I am also going to briefly cover some changes and additions to the PivotTable Options and...

Today, I would like to cover some of the improvements we made in Excel 12 to make PivotTables easier to read and explore. Expand Collapse One of the nice exploration features of PivotTables is the ability to expand and collapse items in order to view values at different levels of detail. In Excel 12, we have added expand/collapse indicators to the PivotTable to make it easy to discover when there are more details to explore (and to make it obvious that this feature even exists!). The expand indicator...

One of the goals we had for our PivotTable work in Excel 12 was to make creating PivotTables a much more approachable task. In this post, I would like to walk through an example of creating a PivotTable in order to highlight the changes we have made in Excel 12. In general, we tried to make the process simpler and more intuitive. As I said in the previous post, PivotTables are great for summarizing large amounts of data. For example, a user might have a table full of sales data (contained in a query...

PivotTables are designed to help users make sense of large amounts of data by providing an easy way to build a summarized report. In addition, PivotTables can be rearranged easily, so that once you have some summary data in a PivotTable, you can look at the same information in many different ways with only a few mouse clicks (the name “PivotTable” is derived from the fact that the process of rearranging your data is known as “pivoting” your data). To illustrate the core capability of PivotTables...

Before I dive into PivotTables, I thought I would mention an Excel 12 feature that resulted from collaboration with our international subsidiaries. Users that work outside North America (and even some users that work within North America) build a lot of spreadsheets that contain multiple currencies. To make this easier for folks, we’ve turned the “$” (or Currency Style) button into a split-button drop-down that contains a list of different currencies the user can select. The feature is pretty straightforward...

In the second article I wrote about Excel Services , I discussed the scenarios that we are targeting with this initial release and also a few scenarios that we will not support. Today I wanted to provide further detail on the latter – specifically, the Excel 12 features that will not be supported in our first version of Excel Services. Excel 12 is a feature-rich application, and it was not possible to support every one of Excel 12’s features in our first version of Excel Services. Instead, we focused...

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, business planners, engineers) that create content in Excel that they would like to re-use and share in a portal or dashboard, but to do so is technically quite challenging. (For those that are not familiar with the term, “dashboard” is generally used...

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 security of data connections – the Data Connection Library (DCL). What is a Data Connection Library? A Data Connection Library (or DCL) is a new type of SharePoint library (much like a document library) that provides a place to store, share, and manage...

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 we ensure that the spreadsheets that users are viewing are the “right” spreadsheets – specifically, how to control which users can author spreadsheets that will be run on the server, and which versions of those spreadsheets will be available for users...