Hey guys every well I have to take several PowerPoint slide presentations that are sent to me and compile the data from embedded spreadsheets into a master slide presentation in PowerPoint.

The spreadsheets aren’t linked to any external excel file, but are the internal ones.

I know I can link from an existing excel file INTO these charts but my question is there any way to link the data OUT OF them so I can have a central true excel file draw the data out and compile it without a day and a half of copy pasting data around to get stuff compiled. When I try to "paste link" it comes up with =Excel.Sheet.12|'Worksheet in 135.pptx'!'!APFT!R1C1:R7C13' but this comes back as a "N/A" in every cell

Thanks guys for your help