Pivot Table Wizard in Excel 2007

N

Nick Hodge

Mike

That doesn't bring up the old 'wizard' which I think is what the OP wants.

If so, to do this add the wizard to the QAT (Office button>Excel
Options>Customise>Command not on ribbon>PivotTable and PivotChart Wizard)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk
 
R

Roger Govier

Hi

Whilst Nick and Ed have given you two methods to bring up the old
wizard, IMHO the new method as indicated my Mike is much easier to use
than the old method.

The field list is clearly visible in a pane, as are the four areas of
Row, Column, Page and Data and it is easier to create your required
layout without having to go back to the wizard>layout each time you want
to make a change.

The only occasion that I have found it necessary to invoke the old
wizard, is if Multiple Consolidation ranges are required, as I have not
yet found a method within XL2007 for achieving this.
 
H

Harlan Grove

Roger Govier said:
Whilst Nick and Ed have given you two methods to bring up the old
wizard, IMHO the new method as indicated my Mike is much easier to
use than the old method.
Click to expand...
....

Perhaps once you've figured out how to use it. But in the short run
the OP may find the old wizard faster to use.
 
R

Roger Govier

Harlan, you may well be right.

However, (again IMO) apart from the fact that MS have renamed Page area
to Report Filter, allocating things to the PT report is much the same.
One major advantage though, is you can see the effect upon your PT as
you move fields between Row, Column and Report filter area on screen
without having to go back through the wizard to Layout, make your
changes and Finish, before you see the effect on the PT itself.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Pivot table 1
Pivot Table - sourced from another Pivot Table 1
How to base a pivot table on another pivot table? 3
pivot wizard buttons 2
Creating a Pivot Table using multiple ranges 1
Pivot Table Wizard "Layout" button disabled (greyed out) 2
Excel 2007 graphs/charts automatically populate with new data 1
How to perform "Reverse pivot table method" in Excel 2007 2

Top