2DB Pivot Table

[Juan Sanchez]

Hi all, I'm almosT sure that the answer to my question is
a straight NO. but here it goes anyway...

Is it possible to create a single pivot table based on 2
different DB tables.

The reason I can't put the 2 DB together is that one of
them has already 65000 rows.

Environment: XL2000, Windows NT

TIA
Juan Sanchez

 

[Debra Dalgleish]

You can create a Pivot Table from multiple consolidation ranges, but you
won't get the same pivot table layout that you'd get from a single
range. There's an example here:

http://www.contextures.com/xlPivot08.html

 

[Juan Sanchez]

Debra, thanks alot, I had already spotted the multiple
consolidated range option, but couldn't get anything out
of it. but using external data sounds like a great idea...
(from the link you sent)

Cheers
Juan