Pivot Table

[HazN]

Hi, can anyone help me with this query - how to make pivot table using two different excel sheets data?

[rakesh9006]

answer

Hi,

you can collect data in one excel sheet and make the Pivot table by useing shortcut keys Alt D P P

Thanks

[Bushfiva]

In the pivotchart wizard, select "multiple consolidation ranges" when asked "where are the worksheet ranges you wish to consolidate". You can then select ranges in different spreadsheets. The feature has changed names a couple of times.

[HazN]

i have data in two different excel files and not in the same file and i need to create pivot table by using the data in these two different files, pls help..

[Bushfiva]

The answer is still in #2.

Assuming you're already used to pivot tables, simply include the filename using the form [filename]sheetname!range rather than sheetname!range

[HazN]

Thanks so much for your help, will check this...