Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

Link Excel cell data to Powerpoint text boxes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dstdst123@excite.com - 09 Jul 2006 14:29 GMT
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:)
Michael Koerner - 09 Jul 2006 15:15 GMT
Jon Peltier a Excel MVP has a macro that will do what you want. Look here
http://peltiertech.com/Excel/Hyperlinks.html

Signature

<>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]

| Hi there
|
[quoted text clipped - 20 lines]
|
| cheers:)
Steve Rindsberg - 09 Jul 2006 18:23 GMT
> Hi there
>
[quoted text clipped - 14 lines]
> 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
================================================
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.