Updating links between excel and powerpoint
If you choose to participate, the online survey will be presented to you when you leave the Technet Web site. I tried your code and while it updates the source file it does not capture the cell references leaving the code useless in the specified case. [workbook.xls]Graphs Chart 3) and the formula does not change the second occurrence of the workbook name in brackets. Source Full Name is blank Can you it in yours and let us know what the msgbox shows please? Auto Update = pp Update Option Manual End With End If End With Hello wilsoff... Source Full Name then it only shows me the first reference to the xlsx, with no square brackets or repeated xlsx filename If I add the same message box to your code it suggests the .If the graphs you want to use in your Power Point presentation will change regularly, it can be a hassle to create them from scratch every time there is an update to the data.It is likely that the data used to create the graph is coming from an Excel worksheet, so why not link the graph on the slide directly to the Excel data. I will describe each method, and then show a table that summarizes the differences.