pivot table from different sheets and from different files

[lezawang]

Hi
Any simple and easy to understand tutorial that you recommend which demonstrates:

1) Pivot table from different sheets
2) Pivot table from different workbooks(files)

Is that possible? Do I need to use 3rd party tools? Thank you.

 

[Fazza]

It is possible, in all Excel versions - and has been available since pivot tables were introduced 20+ years ago. No 3rd party tools are required.

In this old thread I tried to give some explanation, and links to multiple references. Some of the links will likely be out of date by now.

Google will no doubt find lots of newer information. Please search. regards

 

[Fazza]

popped into my head hours later that I'd failed to include the link

https://www.mrexcel.com/forum/excel-questions/315768-creating-pivot-table-multiple-sheets.html