EXCEL & PowerPoint 2007
You don't want to embed the charts into PP but link them as follows:-
1. Click on the EXCEL chart to highlight it then:-
- to copy it.
2. Click in the PP slide where you want to link your chart then:-
Click on the drop down arrow beneath:-
- then click on:-
Paste Special . . .
- window should open.
3. In the:-
- window click on the radio button called:-
- doing this should cause:-
Microsoft Office Excel Chart Object
- to appear highlighted in blue in the field called:-
4. You have now linked your EXCEL chart to your PP presentation.
TO TEST THAT THE ABOVE HAS WORKED
5. Close your PP presentation.
6. Make a change to the EXCEL chart and save it.
7. Open your PP presentation again.
When you do this a warning should pop up.
In that warning click on:-
The change that you have just made in EXCEL should now be reflected in PP.
Save the change to PP.
Your require could be done via Paste Special and insert the Excel file as an object.
Paste Special: Copy the Excel grahs > Paste to PowerPoint>Paste Special>Paste link
Insert the Excel file as an object:Click insert tab>Object>Create from file (Note: check the link).
Then you could update the Excel file and will also update in PowerPoint.
TechNet Community Support
That is how I added the charts to the file. However, I do not get the warning message. In addition, when I click on the chart in PP, then select the Design tab (under Chart Tools), then refresh data, Excel opens. However the source file in Excel DOES NOT open. When I try to close Excel, I get a waring screen asking if I want to save changes to the source file (which I cannot see)
Also, I have Office 2010
- Edited by MAJustice Thursday, November 14, 2013 1:50 PM
Between my point number 6 and my point number 7 leave EXCEL open (don't close it).
When you open the PP presentation you should get the warning at this point (I do and it works OK here).
Does it work now?
I don't need to do the clicking on the chart (and the subsequent steps) that you mention.
You say that you cannot see the source file but your source file is EXCEL isn't it? (so how can you not see it?).
This is a process that repeats monthly, so I have to leave both applications until I need to refresh them again the next month.
At any rate, I currenly have both open, and am making changes to the Excel charts, and it does not change the data in PP. If I click on the "refresh data" button, it tries to open another version of the file (and gives me an error message. For that reason, I suspect the problem has to do with the file paths.
The only solution I see is to delete the existing linked graph and replace with the current one. To me, that defeats the purpose.
The source file is defenitely Excel. I don't know how I cannot see it.
Since you provided more imformation, I think you did not want to re-create the Excel file and PowerPoint file.
But I suppose the issue may be cuased by the two files which there something wrong in them. Thus, could you give me the whole error message when you refresh the data?
We may be force on the troubleshooting with the two files.
TechNet Community Support