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