pivot table with link to a local file

[mlaxx]

Is it possible to have links to a local file in a pivot table?
I searched the internet and found a solution but it refers to the link to a site and not a local file, eg:solution1
I attach an excel file with what I want, but I do not think it will help a lot.

 

[GraH - Guido]

step 1


step 2


step 3 and search for file

 

[mlaxx]

the solution is good for a small number of excel files, but if I have over 100 different excel files it's not productive.

 

[GraH - Guido]

I did not open the workbook initially (as you said "I do not think it will help a lot"), so might have missed a detail or two.
Are those Excel files structured in the same way?

If yes, consider, if available on your ribbon, to load from folder via "Get & Transform" or "Power query".


Which version of Excel are you using? PQ is possible as of version 2010.