Defining Multiple "named" data ranges for Piot Tables in Excel 200

G

Guest

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

Roger Govier

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, Back>Back will get you to the option to choose Multiple
Consolidation range.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automatically import multiple named-ranges from Excel to Access 1
how do I create Excel pivot table with over 65,535 lines of data? 1
Pivot Table - include multiple worksheets with different ranges. 1
Consolidate tables/ranges with text from multiple worksheets 1
Named ranges in Excel 2007 2
version differences in excel 2007 - use of macros & range names 1
pivot table multiple consolidation ranges 3
Dynamic data ranges in pivot tables 3

Top