Jon Peltier a Excel MVP has a macro that will do what you want. Look here
http://peltiertech.com/Excel/Hyperlinks.html

--
<>Please post all follow-up questions/replies to the newsgroup<>
<><>Email unless specifically requested will not be opened<><>
<><><>Do Provide The Version Of PowerPoint You Are Using<><><>
<><><>Do Not Post Attachments In This Newsgroup<><><>
Michael Koerner [MS PPT MVP]


<dstdst123@excite.com> wrote in message
news:1152451762.289811.147280@h48g2000cwc.googlegroups.com...
|
| Hi there
|
| I am using Excel 2002.
|
| On cell A1, I have text "Apple",
| On cell A2, I have text "Banana".
|
| I also have a powerpoint file with two text boxes
|
| What i wanna do:
| 1)
| To create a link between this Excel file and this Powerpoint files.
| So, that, "Apple" will appear in one text box in Powerpoint, and
| "Banana" will appear in another text box.
|
| 2)
| Also, whatever i change or update the Excel cell e.g. "Apple", it will
| be changed in Powerpoint automatically.
|
| Any tips?
|
| Thanks a lot.
|
| cheers
|