Multiple Consolidation Ranges

N

nc

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

Debra Dalgleish

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

nc

Hi Debra

A message appears "ODBC Excel Driver login failed"
"Unrecognised database format"
 
Top