creating pivot table from different files

[siddiq1212]

Dear all
i have 5 files having same header and values are different.
I want to insert a pivot table to have all that value.
How can i do that?

[Careless]

Hi , siddiq1212

for your request , normal way is join all sheet into one sheet ,use excel oledb sql source
, For Not very frequent data updating process .

[siddiq1212]

How can i do that?

[Portuga]

Ideally you would consolidate all your data into 1 sheet and then create the pivot.

If not possible Excel has the Pivot table wizard that allows you to select from diff sheets/workbooks.

This option was available from the start of pivot construction in excel 2003.
This disappeared in 2007 and onwards, but you can still add that option using Alt+D+P (If you have excel in english) or by manually adding the Pivot Table and PivotChart Wizard to your menu ribbon.

http://www.addintools.com/documents/...vot-table.html

Again, the best option is to consolidate your data in 1 sheet and create pivot from there.