Powerpoint embedded excel not updating
Paste link is the better choice in most instances when copying an Excel chart.
This chart was inserted using the Paste link option in the Paste Special dialog box. If you create the Power Point object by linking an Excel range, each time the presentation is opened all objects are updated. By right clicking the Power Point object and choosing Object/Edit, Excel is activated and the range can be modified. If you are suggesting that I copy a range of cells from the master spreadsheet, then in the Powerpoint do Paste Special -- Paste Link, that wouldn't work because that would just paste a refreshable picture that I cant make modifications to (as stated in my original post). I understood that you have two issues: 1) Refreshing When closing and reopening the presentation, all linked objects are updated, so that would eliminate the need to manually do it. By right clicking the Power Point object and choosing Object/Edit, Excel is activated and the range can be modified. Regarding you second point, this is what I am trying to avoid -- manually activating each embedded sheet (which equates to like 225 double-clicks each time I need to update the powerpoint). 2) Modifying Right clicking it will give you the option to edit the object in the original application, Excel in this case. I understood that you have two issues: 1) Refreshing When closing and reopening the presentation, all linked objects are updated, so that would eliminate the need to manually do it. Do Verb (1) End If Next Next End Sub Sub Edit_Embedded() Dim sh As Shape, i% For i = 1 To Active Presentation. Do Verb (1) End If Next Next End Sub hello worf I hope you can help me about this error Compile error: Invalid qualifier the code invalid is in Window(1). Every table and chart which appears in the Report tree contains an invisible code.
When charts and tables are exported form Q to Power Point this invisible code is hidden in the exported objects.
I am trying to figure out how to have the series names updated in the chart when the name is changed in excel.
If I change the series names to "Dogs" "Cats" I would like it to replace the "Men" and "Women" in the same position.
Charts can add a little extra punch to your Power Point presentation instead of listing bullet points of data.
Any chart created in Excel can be copied and pasted into your Power Point presentation.
If you regularly create Power Point presentations that include information from Excel, you will know how frustrating it can be.