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.

"roberta" wrote:

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.