I know it's a late answer but you can use the Pivot Table and PivotChart Wizard by hitting Alt+D+P and select Another PivotTable report or PivotChart report, then select the main PivotTable and modify the report view as you want to have it.
Hi all,
I have an access database and some connections that pull the data from a server, then I have an Excel document that is showing me individual pivot tables for each report, I need to consolidate those Pivot tables in a master one, I don't have the raw data and I know how to get it from...