Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 Wizards? | New Users to Excel | |||
This'll be one for the wizards | Excel Worksheet Functions | |||
wizards,database,field,label,object,objectbar | Excel Discussion (Misc queries) | |||
Excel Math Wizards | Excel Worksheet Functions | |||
How do I active wizards in Excel? | Excel Discussion (Misc queries) |