Powerpoint embedded excel not updating
I am aware there is an option to use paste special, so that the data in the charts can be updated automatically by clicking the update links. Close True End If Next Next Set ppt Workbook = Nothing Set ppt Chart Data = Nothing Set ppt Chart = Nothing End Sub Thanks for the prompt reply.However, my charts needs to be edited by some users. Workbook On Error Resume Next 'update first link ppt Workbook. I had copy and paste this vba in powerpoint and this vba is able to run. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).First of all, excuse me if this question is asked on the wrong Stack Exchange site. I have a Power Point (2010) presentation with two slides. Paste special option does not allow users to edit the charts. However, I am getting a pop up menu asking to update the file in my documents folder. Would you like to answer one of these unanswered questions instead?Hence, I am unable to use this paste special option. My source i.e excel file is located in my desktop folder. Does anyone know a solution or an alternative method to do this? Add Picture( _ File Name:="C:\Users\Name\image1.png", _ Link To File:=mso False, _ Save With Document:=mso True, Left:=(Active Presentation.
However, once I open & close the graphs in PP, they'll show the correct data." To understand why this happens, you first have to know that Power Point itself doesn't make graphs.Here's where you run into the first problem: MSGraph doesn't save any data to files.