hi
create the query(s) first(before the pivot table)
on the menu bar...
dataimport external datanew database query...
follow the wizard.

regards
FSt1

"JR Hester" wrote:

Following a thread from back in 06, I found Debra Dalgliesh's pointers on
cretaing a pivot table from multiple data ranges. MAybe I am brain dead at
this point on Friday afternoon, but I can't seem to stumble onto teh proper
way to generate a MS Query. I start the pivot atble wizard and get to the
datasource/Queries/OLAP cubes. Opening the Queries tab does not give me any
option to create query text, what am I missing?3

Using Excel 2002 on WIN2002

Thanks for your support