PivotTables part 3: More clickable, more compact, and nicely styled

re: PivotTables part 3: More clickable, more compact, and nicely styled

Roy — Wed, 14 Dec 2005 00:47:52 GMT

These new pivot tables are not nearly as intimidating anymore. I predict that the improvements you describe here, combined with the ones you wrote about in your earlier post, will turn the already useful Pivot Table feature into something that the average business user of Excel will be able to use! We will be able to suddenly analyze huge amounts of data and distill it into presentable reports. The world of business will thank you. Can't wait to see it out there.

re: PivotTables part 3: More clickable, more compact, and nicely styled

Jean Martineau — Wed, 14 Dec 2005 05:00:22 GMT

I really like this new layout. It's easy to read and more compact.

Just a suggestion for UI of the New Table Pivot Style: there could be one click lest for the user if the format popup, coming from format button, would be directly in the bottom half part of the table pivot style window (that seems to be empty).

Jean

re: PivotTables part 3: More clickable, more compact, and nicely styled

Shady — Wed, 14 Dec 2005 12:01:02 GMT

Thanks for these great article- I can't say I have ever been excited by the prospect of a new office suite before- but these changes look great.
Are there any equivilent blogs from members of the other office teams. ie showcasing the new features in word etc.
Cheers

re: PivotTables part 3: More clickable, more compact, and nicely styled

Stephen Bullen — Wed, 14 Dec 2005 16:09:23 GMT

It's a shame that in the 'table' layout style, you still haven't included a 'full table' layout, where the headers are shown on all the rows. Doing so would allow us to use a pivot table output as the input to an advanced filter, Dxxx formulae etc.

re: PivotTables part 3: More clickable, more compact, and nicely styled

Harlan Grove — Wed, 14 Dec 2005 21:10:16 GMT

Based on the compact form, the topmost PT image shows the PT spanning A3:B8. The third image shows the same PT with some subcategories expanded spanning A3:B14. So I'll ask questions I asked before about tables: if the implicit outlining in compact form PTs can make the PT change the size of the range that contains it, what happens to cells below or to the right of the PT? Alternatively, if it never makes sense to have anything below or to the right of PTs, why not make them their own sheet type?

Is there any quick way to colapse and expand all outline levels in compact form PTs?

Will the GETPIVOTDATA worksheet function work exactly the same with all PT forms, compact, outline and tabular? Compact and outline forms would have different visibility characteristics than tabular form.

re: PivotTables part 3: More clickable, more compact, and nicely styled

Pivoteer — Wed, 14 Dec 2005 22:14:55 GMT

Love the new layout styles. I would like to see a default measure format as well. Instaed of displaying "General" cell foramt for measures maybe #,##0.00 by default?

re: PivotTables part 3: More clickable, more compact, and nicely styled

Captain Carbohydrate — Wed, 14 Dec 2005 23:20:50 GMT

Styles! Nifty! I was just fighting with Excel, and thought "jeez, why doesn't this thing support CSS?". Obviously no Office program will ever have anything as good as CSS, but any "styles" feature at all would be a huge win.

I still don't know what a Pivot Table is, but that's my own cross to bear...

re: PivotTables part 3: More clickable, more compact, and nicely styled

Colin Banfield — Thu, 15 Dec 2005 00:16:11 GMT

Very nice. Probably the last nail in the coffin for the old Group and Outline feature.

Colin

re: PivotTables part 3: More clickable, more compact, and nicely styled

David Gainer — Thu, 15 Dec 2005 08:16:07 GMT

Greetings – thanks for the comments and feedback.

Roy, glad you are enjoying things.

Jean, thanks for the feedback. The dialog is currently much larger than it will end up.

Shady, I had a list of Office blogs in an earlier post in September. Jensen Harris UI blog has a pretty current list: https://blogs.msdn.com/jensenh/default.aspx

Stephen, I agree. Definitely something we have in mind for a future version.

Harlan, the behaviour of PivotTables in relation to cells around PivotTables has not changed from current versions. PivotTable sheets are an interesting idea, but they would need to be optional, like Chart sheets. Finally, it does make sense in some cases to have cells below or to the right of PivotTables, and we see people do it all the time. I guess that is one of the beauties of spreadsheets – people have the flexibility to design what they want. Yes, there will be a way to do a collapse or expand all – I will get to that soon. GETPIVOTDATA will work the same way with all PivotTable forms.

Pivoteer, that’s a great idea that isn’t currently implemented.

Captain Carbohydrate, keep reading.

Office 12 blogs

linkified — Thu, 15 Dec 2005 19:55:48 GMT

http://en.wikipedia.org/wiki/Office_12#Internal_bloggers_and_evangelists

re: PivotTables part 3: More clickable, more compact, and nicely styled

David Gainer — Thu, 15 Dec 2005 20:07:28 GMT

linkified, thanks for the link.

Excel 2007 documents – easy on the eyes

Microsoft Excel 2007 (nee Excel 12) — Mon, 13 Mar 2006 21:27:43 GMT

One of the themes we focused on with Office 2007 was “great looking documents”.&nbsp; For the next half-dozen...

PivotTable Styles

Microsoft Excel 2007 (nee Excel 12) — Sat, 01 Apr 2006 02:33:20 GMT

Yesterday we looked at Table Styles.&nbsp; Today, I wanted to revisit PivotTable Styles (see a post here...

PivotTables 9: Great support for SQL Server Analysis Services

Microsoft Excel 2007 (nee Excel 12) — Thu, 06 Apr 2006 19:15:16 GMT

Today, I’ll start a series of articles on the improvements we’ve made to PivotTables connected to OLAP...

yet more roadshow questions

Office Rocker! — Thu, 15 Mar 2007 22:35:03 GMT

Technet will windows meeting space have clients written for xp machines, or will it not be a useable

Yet more questions from the roadshow

Office Rocker! — Thu, 15 Mar 2007 22:42:57 GMT

Technet will windows meeting space have clients written for xp machines, or will it not be a useable

Celle con struttura ad albero | hilpers

Celle con struttura ad albero | hilpers — Wed, 21 Jan 2009 19:27:32 GMT

PingBack from http://www.hilpers.it/1811827-celle-con-struttura-ad-albero

Microsoft Excel PivotTables part 3 More clickable more compact and | Wood TV Stand

Mon, 01 Jun 2009 20:50:48 GMT

PingBack from http://woodtvstand.info/story.php?id=10119