Simply copy a range from Excel (The pasted image will now be linked to Excel.If the Excel file and Power Point presentation are both open any changes will update automatically.The following options are then provided: In order for a document to be updated, Q needs to know that you wish to export to that document.This is done via the steps described in Changing the document being exported to.Changes will be reflected on the linked object in Power Point. I can look for an alternative solution for embedded objects, but would like to understand why the above does not fulfill your needs. See my response below: 1) Refreshing: Yes, but if I do the "linking route," the power point object is just a picture, and we want to be able to edit the content of the embedded object within the powerpoint that its located 2) Modifying: This is basically what I want to do, the problem is I have 5 embedded object per slide and about 45 slides, thus totalling 225 embedded objects that I have to right-click, and edit the object in order for it to update/refresh, each and every time that I want to update/refresh the powerpoint data -- this takes a LONG time.
If I change the series names to "Dogs" "Cats" I would like it to replace the "Men" and "Women" in the same position.
To demonstrate the two different paste options when using the Paste Special command, make some changes to data in the original Excel file.
Notice that the corresponding chart in the Excel file immediately changed to reflect this new data.
When Q exports a table or chart to Power Point and Excel it scans the documents to see if the code is contained within the document and, if it is found, the option of updating is provided.
This updating mechanism is relatively robust and can be used to update a document from multiple Q projects and also to update multiple different documents from a single Q project.