| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Defining Multiple "named" data ranges for Piot Tables in Excel 200
How can I input my multiple "named" data ranges when setting up a Pivot Table
in Excel 2007. The facility that was available through Pivot Table Wizard in Excel 2003 for inputting multiple data ranges seemed not available in 2007. I have multiple "named" data ranges and Excel 2007 does not accept " , " between Names..... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Defining Multiple "named" data ranges for Piot Tables in Excel 200
Hi
I don't recall ever being able to enter names separated by a comma. If you are talking about Multiple Consolidation ranges, it does appear to have disappeared as an option for setting the PT source. However, on the PT, if you enter Alt D P then you will invoke the old PT Wizard, BackBack will get you to the option to choose Multiple Consolidation range. -- Regards Roger Govier "Fatih Can1968" <Fatih wrote in message ... How can I input my multiple "named" data ranges when setting up a Pivot Table in Excel 2007. The facility that was available through Pivot Table Wizard in Excel 2003 for inputting multiple data ranges seemed not available in 2007. I have multiple "named" data ranges and Excel 2007 does not accept " , " between Names..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| No idea what "Named Ranges" are. | Excel Discussion (Misc queries) | |||
| Pivot Tables - How can I "reset" the selections in "Row Field"? | Excel Discussion (Misc queries) | |||
| freeze window creates multiple "views" suffixed with ":n" | Excel Discussion (Misc queries) | |||
| Defining "Month" as a variable in VBA | Excel Discussion (Misc queries) | |||
Hybrid Mode
