#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default Pivot table wizards

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 833
Default Pivot table wizards

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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 833
Default Pivot table wizards


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.



"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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 Wizards? MJP08 New Users to Excel 3 July 25th 08 01:24 AM
This'll be one for the wizards mr tom Excel Worksheet Functions 7 May 2nd 07 03:39 PM
wizards,database,field,label,object,objectbar vicky Excel Discussion (Misc queries) 1 July 27th 06 06:40 PM
Excel Math Wizards scain2004 Excel Worksheet Functions 3 October 12th 05 01:07 AM
How do I active wizards in Excel? Peari Excel Discussion (Misc queries) 2 April 26th 05 05:37 AM


All times are GMT +1. The time now is 09:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"