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.