How to Link Excel data to Power Point?

[wec43wec]

I am having difficulty linking / updating my Power Point slides with data pulled from Excel. The only time the data will update is when I manually click on the "update now" option in Power Point under the Edit>Links> OPTION. I have to select UPDATE NOW option. regardless if Automatic or manual is selected. In either case, I just do a manual selection of "UPDATE NOW".

In linking the excel data to Power Point, I do the following -
(a) I copy the range of data in Excel "EDIT>COPY"
(B) In Power Point, I select "EDIT>PASTE LINK".

Note: The Power Point > IMPORT FILE > RANGE option does not seem to allow me to link the "exact" data range that I identify in EXCEL with a sample of a RANGE name as follows a12:e12.

As such, I am not sure if I am following the proper precuedures to link data from Excel to my Power Point presentation.

I have Excel 2003.

 

[SkipVought]

Hi,

In Excel, Select the RANGE that you want in your presentation. Enter a name in the Name box (Use UNDERSCORE rather than SPACE). SAVE your workbook.

You may need to reinsert your link in PP. But UpdateLinks will adjust to the Named Range that you defined.

Skip,

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

 

[wec43wec]

Skip - I continue to have problems linking excel range to PP. What does work is when I copy the range within excel and select PASTE SPECIAL in PP. When I change data within excel the data/graph will change in PP, however PP will not automatically update when I close both files > open and change data in excell and then open PP. The data does not change/update.

As such, I think I will need to use the IMPORT FILE option which allows me to either import an entire file or inport a RANGE Wwhich is what I am trying to do, but it does not work when I either use a NAME RANGE in excel or use a cell location range in excel.

 

[wec43wec]

Skip - the "PASTE SPECIAL" wording on the previous post, should have been "PASTE LINK".

Please note that my data will NOT automatically update in PP unless I click on the individual chart as oppose to the graph updating when I open PP (after having change any data in Excel).

Please provide any help/response.

Thanks