Pivot table wizards

[roberta]

We have just updated from 2003 to 2007. I have an excel report that contains
pivot tables. In the 2003 version I would right click on each table and
click pivot table wizard and then click layout. It would bring up a list of
dates and I would click and drag the old date out and drag the new date in.
When I right click in 07 there is no pivot table wizard. I have tried using
the dates that pop up to the side, but it says that my pivot tables cannot
overlap. Please help.

 

[trip_to_tokyo]

There is no PivotTable wizard in 2007.

Click inside the Pivot Table and the PivotTable Tools will appear in the top
right hand side of the Title Bar.

From here you can select Options or Design.

Please hit yes if my comments have helped.

Thanks.

 

[trip_to_tokyo]

From Pivot Table Data Crunching for Microsoft Office Excel 2007 (by Jelen /
Alexander) page169:-

“Follow these steps to add the PivotTable and PivotChart Wizard custom
toolbar command to the Quick Access toolbar:-

1. Click the Office icon in the upper-left corner of your screen.

2. Select Excel Options to open the Options dialog box.

3. Select Customize to bring up all the available commands that can be added
to the Quick Access toolbar.

4. In the Choose Commands From drop-down box select Commands Not in the
Ribbon.

5. Select the PivotTable and PivotChart Wizard from the list of commands and
click the Add button.

6. Click OK.â€

Please hit Yes if my comments have helped.

Thanks.