-
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!
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules