Results 1 to 10 of 10
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Boise, Idaho, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlink from Excel to Powerpoint (2002)

    We need to link from Excel to a specific Powerpoint slide. Right now all I can get is the entire Powerpoint presentation. Is there any way to go to a specific slide in powerpoint using a hyperlink? Is there any way to do it???

    Information would be greatly appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hyperlink from Excel to Powerpoint (2002)

    I don't have XP. The dialog for inserting a hyperlink probably has changed from Excel 97. There, you can specify a named location within the file. For PowerPoint, enter the number of the slide within the presentation.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Memphis, Tennessee, USA
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink from Excel to Powerpoint (2002)

    Hey, Deb. I'm not sure if this is what you want, 'cuz I don't know the strategy of the hyperlink. But you can insert just the one slide from the presentation as a linked object. It would show the slide itself, but you could resize it or even put in on a seperate hidden sheet and have a hyperlink on the main sheet move to that sheet. There's all kinds of fun you could have with this!
    <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

    In PowerPoint, choose the slide you want in Outline View and hit Copy. In Excel, choose Paste Special (Edit menu) and click Paste Link on the left. Paste. Bam, you have an individual hyperlinked slide of the presentation without all the other slides. And that's turning up the heat a notch.
    <img src=/S/burnup.gif border=0 alt=burnup width=31 height=31>

    -Lenny

  4. #4
    Star Lounger
    Join Date
    Apr 2002
    Location
    Boise, Idaho, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink from Excel to Powerpoint (2002)

    Do you happen to have the exact syntax for the address? Even if it's for 97 it might work.....
    I can link to PowerPoint - but I can't figure out how to specify the page (slide#)

  5. #5
    Star Lounger
    Join Date
    Apr 2002
    Location
    Boise, Idaho, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink from Excel to Powerpoint (2002)

    I appreciate the ideas... Inserting just the one slide from the presentation as a linked object is exactly what I need to do. I can't figure out how to isolate just one slide - when I link the Power Point presentation I get the whole thing from slide #1.
    The problem with the copy idea is we have a Power Point presentation on our network and the slides will be changed.
    I need to go directly to a specific slide that is inside the presentation. I can't put a copy into excel because the copy may not be the "most current version"....
    I hope that makes sense.

    I really appreciate the ideas.

  6. #6
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Memphis, Tennessee, USA
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink from Excel to Powerpoint (2002)

    But the slide WILL update in Excel when it's changed in PowerPoint (provided it's not deleted). That's why you paste it as a link. What kind of changes are you referring to?

    Any hyperlink to a PPT file, no matter what it looks like as the link itself, when launced will launch the entire show. The syntax in PPT97 was to put " - 3" after the hyperlink text for slide three starting point. BUT... it still gave you the ENTIRE presentation, so don't have false expectations. Any hyperlink to a PPT file, when launced, will launch the entire show.

    -Lenny

  7. #7
    Star Lounger
    Join Date
    Apr 2002
    Location
    Boise, Idaho, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink from Excel to Powerpoint (2002)

    Lenny
    Launching the entire show is not the problem. Getting it to open on a specific slide is where I'm having difficulty.

    this is my current syntax in the address line:
    X:BudgetPresentationMgmt&SupportM&SGermaneFY00.ppt

    I don't know how to specify a specific slide in that presentation... slide #3 for example.
    I tried -3 and "-3" right after the .ppt....
    Neither one works.
    should there be a space or something???

    Perhaps 2002 won't do this????

    I hope you don't think I'm a pest-- It's just that if this can be done and I can do it then it'll be a coup for me!!

    I really appreciate you taking the time to correspond with me.

  8. #8
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Memphis, Tennessee, USA
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink from Excel to Powerpoint (2002)

    Okay, Deb. I'm understanding more of what you want now. And, no, you're not being a pest. It's just hard sometimes to comprehend a user's needs and re-explaining it might be needed.

    First, that syntax (-3) is changed in PPT 2002 to #3 (no spaces). So you can choose Insert Hyperlink, and choose the file. Add the #3 to the end and it should do it for you.

    But try this method of pasting hyperlink first...

    1) Open PPT and the file you want to link to in the Outline View.
    2) Select the slide for which you want the presentation to open.
    3) Copy and LEAVE PPT OPEN!
    4) Switch to Excel and open the spreadsheet in which you want to insert the hyperlink.
    5) Click into the cell where the hyperlink will go and type "Click here to see slide" or some other such blurb.
    6) Select the cell again where the hyperlink will go and click the Edit Menu.
    7) Click Paste As Hyperlink.

    Now, you can switch to and close PowerPoint. Switch back to Excel and click the link. It should open the show and start with the slide you chose.

    Lemme know if that one works for you.

    -Lenny

  9. #9
    Star Lounger
    Join Date
    Apr 2002
    Location
    Boise, Idaho, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink from Excel to Powerpoint (2002)

    Lenny
    Thank you - that works!!!!!!!!!!
    You are the most wonderfullest, bestest and awsomest person in the world...
    I've been trying to get this done for MONTHS - You have really made my day...

    Maybe someday I can return the favor....

  10. #10
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Memphis, Tennessee, USA
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink from Excel to Powerpoint (2002)

    Awwwww. <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

    -Lenny

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •