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.
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).
When you embed an Excel chart in Power Point, any updates you make to the original Excel chart will automatically update in your presentation, as long as the files remain in the same location.
This helps the data stay in sync, so you won't have incorrect or out-of-date information in your chart. An Excel spreadsheet containing the chart's source data will appear.
I think the solution lies in writing a vba in powerpoint. If you need to edit the charts then clearly you will either need to edit the underlying Excel files, or be able to edit in Power Point As you are using Power Point2007 which provides full Excel support (unlike Power Point 2003 which has a datasheet) I would Part 1 This gives you a flexible solution, except that Excel underlying each chart cannot be updated automatically via a Power Point menu Update Links command.
Can any expert here offer to write this vba code to allow all the charts to be updated in powerpoint? Part 2 You can use the code below to test each whether each shape on each slide has a chart.