In a PowerPoint deck I have a pivot chart pasted as a link. That pivot chart resides in a summary workbook. The summary workbook collects data from a set of several data workbooks using references to external content. So the data flow is like this:
{Data1.xlsx, Data2.xlsx, ..DataN.xlsx } -->...