I am new to Macros world but know coding

Does anyone have tried and tested script in Excel to update the ppt links from one excel to another please.



I have tried this and its breaking the ppt more than fixing it.

exceloffthegrid.com/edit-links-in-powerpoint-using-vba/​



In my ppt the links are

1- charts - copied as pasted in the ppt as Paste special - keep source formatting and links

2- Excel sheets / Tables copied and paste link as an excel worksheet (code) object

​​

On few occasions, the links of to the worksheets were updated but links to the charts are just not updating.



On other occasions when the links to the tables are updated they dont display the respective table but a patch of excel from another sheet from excel as an embedded object.



I am keen to just refresh everything and go with a new script which is perhaps more mature than the above. Also happy to change the way I copied charts and worksheets on the ppt

One thing I would like to consider is if I may call the values of ppt, old and new excel patch from a table cell please, as opposed to editing the call all the time.


Appreciate your help