VBA PPT: Link all graphs + object in a PPT to a different Excel source file

Hey Guys,

So I have a small issue that I saw happened to other people, but slightly different from mine.

I have a PowerPoint file/report with graphs & macro-enabled worksheet objects, both linked to a specific Excel file as a source.

Now as I want to share these 2 files (Excel + PowerPoint) to my colleagues so they can generate PPT reports themselves when updating the Excel, all the graphs & objects need to be re-linked to the matching Excel file that was sent to them.

Is there a VBA code that I can implement in the PowerPoint that can help me set the "new" Excel file (just different location) as the source for all graphs & worksheet objects?

Many many thanks!