M
mrchadmoody
Hi,
How do I bring up the Pivot Table Wizard in Excel 2007?
How do I bring up the Pivot Table Wizard in Excel 2007?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike Middleton
E
Ed Ferrero
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
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.
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.
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.
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.