You can run ms query in excel. E.g your workbook is A containing database dbA and dbB, you have to run ms query on new work book (i've tried in a sigle workbook but it fails). in ms query, prior to join table dbA and dbB, make sure your both table has same key field. zai...@e61i
- original message - Subject: ]] XL-mania [[ pivot table query... From: "pranav" <[email protected]> Date: 11/02/2009 4:07 pm want to make pivot table using 2 worksheet. i used whole row in 1 sheet excel 2003 i cant use office 2007 because i have register copy of 2003 office.. sheet one have 65536 row data sheet two have 22000 row data i want to see a result in only one pivot table.. can any one help me... pranav
