Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » PivotTables   (RSS)
Thursday, May 08, 2008 10:07 PM

PivotTables: Calculated Items

Today's author: David Gainer, a Program Manager on the Excel team. 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
Posted by Joseph Chirilov | 6 Comments
Filed under: ,
Tuesday, March 04, 2008 6:48 PM

Example file for PivotTable / Data Validation Trick

Recently I posted an article discussing how PivotTables can be used on Excel Services to mimick the Data Validation feature . The author, Dany Hoter, sent me a copy of the file he used in the example screen shots and I never got around to posting it for
Posted by Joseph Chirilov | 3 Comments
Wednesday, February 13, 2008 12:50 AM

A PivotTable Trick That Brings Data Validation to Excel Services

Today's author: Dany Hoter, a product planner who works on the Excel Services team. Excel has a feature called Data Validation that controls the possible values a user might enter into a cell or a range of cells. As you can see there are many options
Posted by Joseph Chirilov | 17 Comments
Tuesday, February 05, 2008 10:00 PM

Common Questions Around Excel 2007 OLAP PivotTables

Today's author: Allan Folting, a program manager who works on the Excel team. I have gotten lots of questions from customers around specific functionality in Microsoft Excel 2007 PivotTables that is missing when connected to Microsoft SQL Server 2005
Posted by Joseph Chirilov | 13 Comments
Tuesday, April 10, 2007 10:48 AM

New Whitepaper - Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables

Another Excel 2007 whitepaper is available. According to the overview, " Microsoft Office Excel 2007 takes advantage of most of the features in Microsoft SQL Server 2005 Analysis Services. To take full advantage of these features, it is important to keep
Posted by David Gainer | 9 Comments
Thursday, June 22, 2006 8:13 AM

Calling all PivotTable users: Let us know how you like to summarize your data...

A few months back I wrote several posts about the improvements that we made to PivotTables in Excel 2007. I even showed how summarizing data in different ways is now just a right click away on the “Summarize Data By...” menu. What I didn’t show was that
Posted by David Gainer | 24 Comments
Filed under:
Tuesday, April 04, 2006 2:41 PM

A Small Piece Of Pleasant News For Those Of Us That Write Code In Office, Plus Some More Screenshots …

Any readers that have written VB using the VBA editor in Microsoft Office has probably noticed that historically, their mouse scroll wheel (or equivalent) does not work in the code window. I just noticed in recent builds of Office 2007 that it does. I
Posted by David Gainer | 11 Comments
Friday, March 31, 2006 4:11 PM

PivotTable Styles

Yesterday we looked at Table Styles . Today, I wanted to revisit PivotTable Styles (see a post here where I introduced PivotTable styles a few months ago – you might want to re-read that before proceeding). This post will be a bit shorter, because most
Posted by David Gainer | 13 Comments
Thursday, February 16, 2006 9:19 PM

Managing External Database Connections in Excel 12

Now that we have covered OLAP formulas, I would like to explain a set of work we did in the area of “connection management” in Excel 12 workbooks. Specifically, I want to show you three new things that you can do in a workbook that is connected to external
Posted by David Gainer | 9 Comments
Wednesday, February 08, 2006 9:23 PM

SQL Server Analysis Services support – the list

I have had a number of emails in the last week asking for a list of the SQL Server Analysis Services features that we support, asking for a list of the SQL Server Analysis Services features that are new in their 2005 release, etc., so here is a list that
Posted by David Gainer | 9 Comments
Friday, January 13, 2006 10:46 AM

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:
Thursday, January 12, 2006 8:24 PM

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
Posted by David Gainer | 1 Comments
Tuesday, January 10, 2006 10:29 PM

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
Posted by David Gainer | 5 Comments
Thursday, January 05, 2006 5:40 PM

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
Posted by David Gainer | 4 Comments
Thursday, December 29, 2005 3:12 PM

PivotTables 9: Great support for SQL Server Analysis Services

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,
Posted by David Gainer | 4 Comments
More Posts Next page »
 
Page view tracker