linking pivot table data to another workbook

[russkris]

Excel 2016

Hi,

I know very little about pivots

I have a pivot table in a few separate workbooks, what I would like to do is have a separate workbook that displays the pivot table together. The data is regional and contains the same fields.

I have tried having the workbooks open, selecting 'table 1' and creating a pivot in the new workbook, which works but once the source is closed and you re-open the consolidated workbook it wont update as the source isn't open.


Any help would be greatly appreciated.

[MarvinP]

Hi russkris,

Do you try to Refresh the Pivot Table after re-opening the data workbook?
https://support.office.com/en-us/art...2-7C07AE23DBBD
I've never seen the options suggested in this link, but I don't have SharePoint either. I wonder if you can see them from your version of excel.

[russkris]

Hi Marvin,

Thank you for your time to reply.

I will have a look at that link and get back to the thread.

[russkris]

Error says:
"We couldn't get the data from 'Table1' in the workbook 'LOCATION'. Open this workbook in excel and try again

[MarvinP]

Hi russkris,

Might you have the latest version of Excel with "Power Query" tools in it? If you did then:
https://support.office.com/en-us/art...8-b68e9e616f5a
I'm not sure the above link will help. Can you give us more information?

You are trying to pull data from a pivot table and not the original data? Why not link the data itself instead of the Pivot?

[russkris]

Power Query.. Excellent.. That looks like the way to go..

Thank you very much