Multiple Consolidation Ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have found out how to create a normal pivot table from multiple ranges,
by using MS Query to join the data. One sample file contains the pivot table,
the other contains the source data tables at
http://www.contextures.com/excelfiles.html

Instead of using two files can I using only one file with the source data
tables being in different sheets? I have tried it does not seem to work.

Thanks in advance.
 
What happened when you tried it?
I have found out how to create a normal pivot table from multiple ranges,
by using MS Query to join the data. One sample file contains the pivot table,
the other contains the source data tables at
http://www.contextures.com/excelfiles.html

Instead of using two files can I using only one file with the source data
tables being in different sheets? I have tried it does not seem to work.
Click to expand...
 
Hi Debra

A message appears "ODBC Excel Driver login failed"
"Unrecognised database format"
 
You must log in or register to reply here.

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

Single Filter to change all Pivot Tables in a Workbook 8
Pivot tables - memory issues - please help 2
PivotTable - multiple consolidation ranges 1
Consolidate tables/ranges with text from multiple worksheets 1
Change Data Source for Multiple Pivot Tables 1
Pivot Table - include multiple worksheets with different ranges. 1
Pivot Table-Multiple Consolidation Ranges 3
Multiple Pivot Tables from Same data source 1

Back
Top