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

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

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

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 buttonExcel OptionsCustomiseselect All Commands in
the first dropdownScroll down to Pivot Table and Pivot Chart WizardAdd
--

Regards
Roger Govier

"Mikael Lindqvist" wrote in
message ...
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

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

Works like a charm, many thanks!!! :

Cheers,
Mikael

"Roger Govier" wrote:

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 buttonExcel OptionsCustomiseselect All Commands in
the first dropdownScroll down to Pivot Table and Pivot Chart WizardAdd
--

Regards
Roger Govier

"Mikael Lindqvist" wrote in
message ...
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