get filename of pivottable

[rawjdog]

Any suggestions on how to write a formula that will return the filename of the source of a pivot table.

I have two files. File1 is data, file2 has a pivot table of the data from file1.

So, in file2 i want a formula that tells me the filename, path, etc, of file1 by looking at the pivot table in file2.

 

[Fazza]

Maybe (via VBA) using the connection information? Extract the file name from it. Start with

? your_sheet_reference.pivottables(1).pivotcache.connection