Updating Source excel link file location on ppt

[baleshst]

hi,

I have a power point presentation, which has several object links to an excel workbook.

I have changed the location of the excel workbook and i need to update the new location of the excel workbook.

Updating location of a excel file through info>edit links takes a lot of time.

Please let me know if there is addin or a vba code which would help me in batch editing the new excel file location.

thanks

[John Wilson]

Probably but you need to at least specify the old and new paths to the linked file.

[YorickG]

Hi, here you can find great article with a solution to your problem.

https://exceloffthegrid.com/edit-lin...int-using-vba/

Best