Link Excel cell data to Powerpoint text boxes

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

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
|

In article <1152451762.289811.147280@h48g2000cwc.googlegroups.com>, wrote:
> 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.

Do you want the PPT show to change DURING a slide show or is it enough that it
updates from the XLS each time you open the PPT file?

If the latter, just select the text in Excel, copy it, then go to PPT and
choose Edit, Paste Special, Link to paste in LINKED text.

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================