December 2005 - Posts
Today, I’ll start a series of articles on the improvements we’ve made to PivotTables connected to OLAP (OnLine Analytical Processing) data sources, specifically Microsoft SQL Server Analysis Services models (in addition to its relational database product,
Read More...
In this article, I’ll cover a small yet very useful PivotTable feature – deferring PivotTable updates. In current versions of Excel, PivotTables are updated each time a field is added, removed, or moved to a different position. For PivotTables based on
Read More...
In a series of previous articles I introduced the new conditional formatting capabilities in Excel 12 (see here for the whole series of posts). Today I want to add one more article to the series, which is the work we have done to make conditional formatting
Read More...
As I mentioned a few articles back, PivotTables enable users to summarize data in an easy-to-read report. Once a user has a summary of something they are interested in, they often want to further explore their data by seeing it ordered differently, by
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...