| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007: Create a pivot table where data is in multible sheets
Hi
I would like to make a pivot table in a file, where the data area is in 15 other sheets in the workbook. The problem is, that I cannot find the function in Excel 2007, maybe because I have just got the new version of Excel yesterday, and haven't got used to the new look. In Excel 2003 there was a function during the creation of a pivot table, where it was possible to create the pivottable based on multible areas, but I don't think it was very usefull, because it wasn't possible to make the same build up of the pivottable as in a pivottable based on only one data area. I hope some of you out there can help me solving my problem. Kind regards Kenneth Andersen |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2007: Create a pivot table where data is in multible sheets
Hi Kenneth
There doesn't seem to be the option for Multiple Consolidation ranges in XL2007. However, if whilst in a cell within any of your source table, you type Alt+D+P it will invoke the old PT wizard and you can select your ranges from there. -- Regards Roger Govier "Kenneth Andersen" wrote in message ... Hi I would like to make a pivot table in a file, where the data area is in 15 other sheets in the workbook. The problem is, that I cannot find the function in Excel 2007, maybe because I have just got the new version of Excel yesterday, and haven't got used to the new look. In Excel 2003 there was a function during the creation of a pivot table, where it was possible to create the pivottable based on multible areas, but I don't think it was very usefull, because it wasn't possible to make the same build up of the pivottable as in a pivottable based on only one data area. I hope some of you out there can help me solving my problem. Kind regards Kenneth Andersen |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2007: Create a pivot table where data is in multible she
Hi Roger
Thank you for your answer. I'm using the danish version of Excel 2007, and the shortcut Alt+D+P doesn't work. Could you please tell me what the menu Alt+D+P means. It would help me to find out what the danish menu is. Kind regards Kenneth Andersen "Roger Govier" skrev: Hi Kenneth There doesn't seem to be the option for Multiple Consolidation ranges in XL2007. However, if whilst in a cell within any of your source table, you type Alt+D+P it will invoke the old PT wizard and you can select your ranges from there. -- Regards Roger Govier "Kenneth Andersen" wrote in message ... Hi I would like to make a pivot table in a file, where the data area is in 15 other sheets in the workbook. The problem is, that I cannot find the function in Excel 2007, maybe because I have just got the new version of Excel yesterday, and haven't got used to the new look. In Excel 2003 there was a function during the creation of a pivot table, where it was possible to create the pivottable based on multible areas, but I don't think it was very usefull, because it wasn't possible to make the same build up of the pivottable as in a pivottable based on only one data area. I hope some of you out there can help me solving my problem. Kind regards Kenneth Andersen |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2007: Create a pivot table where data is in multible she
It's the shortcut from Excel 2003 to open the Data menu (Alt+D), and
select PivotTable and PivotChart report (P). Kenneth Andersen wrote: Hi Roger Thank you for your answer. I'm using the danish version of Excel 2007, and the shortcut Alt+D+P doesn't work. Could you please tell me what the menu Alt+D+P means. It would help me to find out what the danish menu is. Kind regards Kenneth Andersen "Roger Govier" skrev: Hi Kenneth There doesn't seem to be the option for Multiple Consolidation ranges in XL2007. However, if whilst in a cell within any of your source table, you type Alt+D+P it will invoke the old PT wizard and you can select your ranges from there. -- Regards Roger Govier "Kenneth Andersen" wrote in message ... Hi I would like to make a pivot table in a file, where the data area is in 15 other sheets in the workbook. The problem is, that I cannot find the function in Excel 2007, maybe because I have just got the new version of Excel yesterday, and haven't got used to the new look. In Excel 2003 there was a function during the creation of a pivot table, where it was possible to create the pivottable based on multible areas, but I don't think it was very usefull, because it wasn't possible to make the same build up of the pivottable as in a pivottable based on only one data area. I hope some of you out there can help me solving my problem. Kind regards Kenneth Andersen -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2007: Create a pivot table where data is in multible she
And instead of a shortcut, you could add the PivotTable Wizard to the
Quick Access Toolbar. In the English version, click the Office button, then click Excel Options, and click Customize In the list at the top left choose All Commands Scroll down to find PivotTable and PivotChart Wizard Select that command, and click Add, then click OK Kenneth Andersen wrote: Hi Roger Thank you for your answer. I'm using the danish version of Excel 2007, and the shortcut Alt+D+P doesn't work. Could you please tell me what the menu Alt+D+P means. It would help me to find out what the danish menu is. Kind regards Kenneth Andersen "Roger Govier" skrev: Hi Kenneth There doesn't seem to be the option for Multiple Consolidation ranges in XL2007. However, if whilst in a cell within any of your source table, you type Alt+D+P it will invoke the old PT wizard and you can select your ranges from there. -- Regards Roger Govier "Kenneth Andersen" wrote in message ... Hi I would like to make a pivot table in a file, where the data area is in 15 other sheets in the workbook. The problem is, that I cannot find the function in Excel 2007, maybe because I have just got the new version of Excel yesterday, and haven't got used to the new look. In Excel 2003 there was a function during the creation of a pivot table, where it was possible to create the pivottable based on multible areas, but I don't think it was very usefull, because it wasn't possible to make the same build up of the pivottable as in a pivottable based on only one data area. I hope some of you out there can help me solving my problem. Kind regards Kenneth Andersen -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2007: Create a pivot table where data is in multible she
Hi Debra
Thank you for your answer. The things you wrote, only lead to the ordinary pivot wizard. To get the oportunity to create a pivot table based on multiple areas, I think Rogers advise is correct, if it leads to the old pivot wizard, because in Excel 2003 the wizard let the user choose a function (I do not know the english name for this function) where it was possible to create the pivot table based on multiple areas. But my problem is, that the keyboard shortcut Alt+D+P doesn't work in the danish version of Excel 2007. Therefore I would like to know what the menu path is, so i can translate it to danish, and thereby find out what the danish keyboard shortcut is. Kind regards Kenneth Andersen "Debra Dalgleish" skrev: And instead of a shortcut, you could add the PivotTable Wizard to the Quick Access Toolbar. In the English version, click the Office button, then click Excel Options, and click Customize In the list at the top left choose All Commands Scroll down to find PivotTable and PivotChart Wizard Select that command, and click Add, then click OK Kenneth Andersen wrote: Hi Roger Thank you for your answer. I'm using the danish version of Excel 2007, and the shortcut Alt+D+P doesn't work. Could you please tell me what the menu Alt+D+P means. It would help me to find out what the danish menu is. Kind regards Kenneth Andersen "Roger Govier" skrev: Hi Kenneth There doesn't seem to be the option for Multiple Consolidation ranges in XL2007. However, if whilst in a cell within any of your source table, you type Alt+D+P it will invoke the old PT wizard and you can select your ranges from there. -- Regards Roger Govier "Kenneth Andersen" wrote in message ... Hi I would like to make a pivot table in a file, where the data area is in 15 other sheets in the workbook. The problem is, that I cannot find the function in Excel 2007, maybe because I have just got the new version of Excel yesterday, and haven't got used to the new look. In Excel 2003 there was a function during the creation of a pivot table, where it was possible to create the pivottable based on multible areas, but I don't think it was very usefull, because it wasn't possible to make the same build up of the pivottable as in a pivottable based on only one data area. I hope some of you out there can help me solving my problem. Kind regards Kenneth Andersen -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2007: Create a pivot table where data is in multible she
No, it is the old wizard that Debra described how to add to the QAT
The new button is called "Insert PivotTable" but the there is one is called "PivotTable and PivotChart Wizard" The latter will give you the option of selecting multiple consolidation ranges To find out the keyboard shortcut for a Danish Excel, find someone with excel 2003 or earlier since Alt + D + P is a command for the old menu system, Alt will active the menus, D will select the data menu and P the pivot table that is in the data menu. -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Kenneth Andersen" wrote in message ... Hi Debra Thank you for your answer. The things you wrote, only lead to the ordinary pivot wizard. To get the oportunity to create a pivot table based on multiple areas, I think Rogers advise is correct, if it leads to the old pivot wizard, because in Excel 2003 the wizard let the user choose a function (I do not know the english name for this function) where it was possible to create the pivot table based on multiple areas. But my problem is, that the keyboard shortcut Alt+D+P doesn't work in the danish version of Excel 2007. Therefore I would like to know what the menu path is, so i can translate it to danish, and thereby find out what the danish keyboard shortcut is. Kind regards Kenneth Andersen "Debra Dalgleish" skrev: And instead of a shortcut, you could add the PivotTable Wizard to the Quick Access Toolbar. In the English version, click the Office button, then click Excel Options, and click Customize In the list at the top left choose All Commands Scroll down to find PivotTable and PivotChart Wizard Select that command, and click Add, then click OK Kenneth Andersen wrote: Hi Roger Thank you for your answer. I'm using the danish version of Excel 2007, and the shortcut Alt+D+P doesn't work. Could you please tell me what the menu Alt+D+P means. It would help me to find out what the danish menu is. Kind regards Kenneth Andersen "Roger Govier" skrev: Hi Kenneth There doesn't seem to be the option for Multiple Consolidation ranges in XL2007. However, if whilst in a cell within any of your source table, you type Alt+D+P it will invoke the old PT wizard and you can select your ranges from there. -- Regards Roger Govier "Kenneth Andersen" wrote in message ... Hi I would like to make a pivot table in a file, where the data area is in 15 other sheets in the workbook. The problem is, that I cannot find the function in Excel 2007, maybe because I have just got the new version of Excel yesterday, and haven't got used to the new look. In Excel 2003 there was a function during the creation of a pivot table, where it was possible to create the pivottable based on multible areas, but I don't think it was very usefull, because it wasn't possible to make the same build up of the pivottable as in a pivottable based on only one data area. I hope some of you out there can help me solving my problem. Kind regards Kenneth Andersen -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 pivot table data is truncated | Excel Discussion (Misc queries) | |||
| Excel 2007 (BETA) Missing data when doing pivot table | Excel Discussion (Misc queries) | |||
| How do i create pivot table from 2 sheets. | Excel Discussion (Misc queries) | |||
| Pivot Table--How can I create from multiple sheets? | New Users to Excel | |||
Hybrid Mode
