How do I get data from multiple tables in my external database into excel 2007. 2003 used the wizard however, the wizard is not available in 2007.
Thanks for your help!
Dixiesky
How do I get data from multiple tables in my external database into excel 2007. 2003 used the wizard however, the wizard is not available in 2007.
Thanks for your help!
Dixiesky
Hello , The 'old' PivotTable wizard still exists in Excel 2007 but to use it you will either need to customise the Quick Access Toolbar to add the button 'PivotTable and PivotChart Wizard' from the 'Commands Not in Ribbon' or 'All Commands' category, or alternatively you can use the Excel 2003 keyboard shortcut sequence Alt-D-P to launch the wizard.
To create a PivotTable report, follow these steps:
1. Open the workbook where you want to create the PivotTable report. If you're basing the report on an Excel list or database, click a cell in the list or database.
2. On the Data menu, click PivotTable and PivotChart Report.
3. In step 1 of the PivotTable and PivotChart Wizard, choose the type of data you will use, and then click PivotTable under What kind of report do you want to create?
4. In step 2 of the wizard, follow the instructions for locating your data. If you're retrieving external data for the PivotTable report, you can get more information about using Microsoft Query or the Query Wizard from either Excel Help or Query Help.
5. In step 3 of the wizard, click Finish.
See this video for more help :Building a Pivot Table in Excel 2007
If you want to retrieve the data from multiple tables and then compare those data results, Microsoft provides an application called Excel Compare Data in Two Tables Software 1.1 to do the same purpose.
Download this software.
Bookmarks