Welcome to MSDN Blogs Sign in | Join | Help

January 2006 - Posts

A pause in the proceedings

For the next week and a half, I am going to be on the road visiting customers, so I probably will not be posting new content to the Excel 12 blog (I will try and reply to comments that show up). I will definitely pick up again after the travel is done,
Posted by David Gainer | 7 Comments

Pivot Tables grand finale: Tricks with the Values field

This is going to be the last PivotTable post, at least for a while. Unlike the last several posts, the subject matter that follows applies to any PivotTable, not just those connected to SQL Server Analysis Services. In current versions of Excel, one of
Posted by David Gainer | 7 Comments
Filed under:

PivotTables 12: Filtering OLAP data, and some “persistence” improvements

In a previous post I covered the new sorting and filtering capabilities of Excel 12 PivotTables . Those features are available for any PivotTable, regardless of the data source. There are a few additional filtering options available for PivotTables connected

PivotTables 11: Key Performance Indicators, Actions, and Named Sets

Today, I will cover three additional features of Analysis Services that Excel 12 PivotTables supprt – Key Performance Indicators, Actions, and Named Sets. Key Performance Indicators SQL Server Analysis Services 2005 introduced the notion of key performance

PivotTables X: Server formatting, translations, member properties

In this post I’ll walk you through three Analysis Services features that we now support in Excel PivotTables – server formatting, translations, and member properties. One thing to keep in mind as you read is that since all these are defined in Analysis

Quick detour #3: Updates we have made to XLLs

In the past few months, I have written a couple of articles ( big grid , multi-threaded calculation ) that prompted comments and questions along the lines of “what about XLLs?” Since the email questions have actually been picking up in frequency (I guess
 
Page view tracker