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. You can also prevent Word from automatically updating links in all the documents that you open.You can do this as a security measure, to prevent updating documents with files that are potentially from an untrusted source.The presentation object can be embedded only, not linked.By default, linked objects are updated automatically.This means that Word updates the linked information every time you open the Word file or any time the source Power Point file changes while the Word file is open.However, you can change the settings for individual linked objects so that the linked object is not updated or so that it is updated only when the reader of your document chooses to manually update it.
Easily and reliably insert video directly into your slide deck. The main differences between linked objects and embedded objects are where the data is stored and how you update the data after you place it in the destination file.You place either a link to the object or a copy of the object in the document.Paste special option does not allow users to edit the charts. Would you like to answer one of these unanswered questions instead?Hence, I am unable to use this paste special option.