How-to create a list from a summary table? (Office 2007)

[Mikael Lindqvist]

Hi,

I've been using Mr J. Walkenbach's "trick" on how to create a "list" from a
"summary table" but that was with Office 2003 and I can't get it straight
with Office 2007.

This how I used to do it (with Office 2003):

1. Click inside the summary-table (matrix).
2. Pivot table, multiple consolidation range option (I can't find this with
Office 2007)
3. Choose "I will create page fields option"
4. Specify range in summary table
5. Remoe row and column fields-button
6. Click OK and double-click on the data-cell. Voila!

But - how to do this with Office 2007?

I can't find any option where I choose "Multiple Consolidation Range" and
then "I will create the page fields option.

Any help much appreciated!

Cheers,
Mikael

 

[Roger Govier]

Hi Mikael

Use Alt+D+P to bring up the PT Wizard at the point where you can select
Multiple Consolidation Ranges.

The feature has been deprecated in 2007, hence not available through any
2007 menu structure, but all the 2003 keyboard shortcuts work.

You an also all an icon to the QAT (Quick Access Toolbar.
Press the round Office button>Excel Options>Customise>select All Commands in
the first dropdown>Scroll down to Pivot Table and Pivot Chart Wizard>Add

 

[Mikael Lindqvist]

Works like a charm, many thanks!!! :>

Cheers,
Mikael