Complete Source Table - Pivots

[Yohnson]

Hello Friends,

I am working on a project where I have a Excel-File based on a Table stored on a Server.

The file only contains the PivotTables for a variety of overviews and I can create the sub-tables of the Data represented when I doube click it.


My question now, is it possible to re-create the entire source-table like I do with sub-table from Single columns?
I need the entire source-table as an Input for another file and I cant access it at the moment.

Alternativ: Is there a way to reference the Data-Source of my Pivot Table as a Data-Source for my Table in another File?
Just the Source?


Thank you very much in advance!

[JeteMc]

I am not sure that this will work for data that is on a server, however it may be worth a try.
If one of the pivot tables produces grand totals by rows and columns then select the the cell that intersects both grand totals and double click.
Best of luck.