How to Link Excel data to More Than One Power Point Graph

[wec43wec]

I previously sent a post (Nov 5, 2008) where I asked how to link excel data to Power Point and update the PPT slide each time I change the excel data.

After spending many hours trying to tackle this issue, it seems that PPT only updates the PPT slide when I activate the individual slide.

The problem is that I would have to activate each of the 30 plus slides in order that the excel data will link to PPT. I thought that the link to PPT would work like the link to a 2nd Excel file that ask the user each time the file is open, if he/she want to update the file.

Does anyone know how to update PPT using excel automatically?

Note: The path I took to link the data is as follows:

Excel - entered data in rows A1 thru C2
Excel - Copy cells A1 thru C2
PPT - double click the graph to show the PPT datasheet
PPT - placed the cursor on the PPT datasheet
PPT - Selected Edit>Paste as hyperlink>ok

 

[SkipVought]

Hi,

Just tested this.

2 charts as Chart Sheets. Column chart & Bar chart.

Copied each and did a Paste Special LINK, each in a separate slide.

I then changed the source data for each chart saved the workbook and closed.

Went back to the ppt and UPDATED each link.

Each chart displayed correctly.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[wec43wec]

Skip - thanks !

Question - are you saying that I must go into "each" graph and select from PPT - Edit> Links> Update Now?

If so that is good, however I was expecting MS to have Excel and PPT so that it would be done automatically like the links within 2 different excel files that automatically update when you open the target file.

Please confirm that you must manually use the Edit > Links > Update Now option separately for "each" graph in order to download data from excel to PPT.

Thanks

 

[SkipVought]

When I open the saved ppt, if I UPDATE LINKS, both charts update correctly.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[wec43wec]

OK Skip - I will try again, however PPT does not give me an option to UPDATE Links when I open the PPT file.

It only allows me to UPDATE LINKS after I activate one of the graphs. At that time, it will update, however I must go to the next slide and do the same thing.

Maybe I am missing a step in this process. I just tried again and the same issue occurred.

 

[SkipVought]

Do you have the AUTOMATIC option seleted in Edit > Links?



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[summitan]

Having a similar problem. I have an existing ppt with about 90 embeded charts that are linked to 1 excel file. I want to point the embeded source links of the ppt charts to another excel file. Can I do this in one shot or do I have to update each slide?

Thank you.

 

[wec43wec]

**Do you have the AUTOMATIC option selected in Edit > Links?


Skip - the AUTOMATIC option "is" selected in the slides.

I must activate the actual PPT slide before the data is updpated in the PPT graph. I must do this for EACH slide in order for the graph to update.

Is there an easier way to complete this task?

 

[SkipVought]

"the AUTOMATIC option "is" selected in the slides."

In the SLIDES???

It is not a SLIDES thing but am APPLICATION thing. So please clarify that Edit > Links has AUTOMATIC on Each and Every link to Excel. You must select each link in order to observe and verify.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}