Batch Edit Links
Hello,
I have created a powerpoint presentation that links from multiple sheets within one excel workbook.
The issue is I need to update the ppt. based on selecting different excel workbooks (which have the same worksheets). I am able to change the source files individually under the "edit links to file" option.
How can I change the source in powerpoint to schange all the sliLE to another excel workbook at once? Is there a vba code that can do this?
Any advise will be much appreciated.
Thanks
|