PowerPoint Tips Blog

Helping you with presenting, PowerPoint, and speaking

  • Home
  • Blog
  • Tips
  • E-Store
  • Training
  • About
  • Affiliates
  • Advertise
  • Contact
You are here: Home / Design / Hyperlinks / Link to a specific PowerPoint 2003, 2007 or 2010 slide from Microsoft Word or Excel

Link to a specific PowerPoint 2003, 2007 or 2010 slide from Microsoft Word or Excel

June 14, 2012 by Ellen Finkelstein 37 Comments

READ LATER - DOWNLOAD THIS POST AS PDF >> CLICK HERE <<

In another tip, “Hyperlink to a specific slide in another presentation, or specific location in another file,” one of the topics I cover is how to create a hyperlink in PowerPoint that links to a specific location in Word or Excel. I also explain that you can link to a specific slide in another PowerPoint presentation by adding the # symbol, the slide number, a period, a space and the slide’s title.

Here’s an example.

As I note in that earlier tip, hyperlinking to another file is a great way to connect content that exists in more than 1 file. You might want to put a hyperlink in a report created in Word or a spreadsheet created in Excel that sends readers to a specific slide in a PowerPoint presentation.

powerpoint-tips-hyperlink-from-excel-word-to-powerpoint-2003-2007-2010-1

Link from Word or Excel to PowerPoint

Suppose you want to link from Word or Excel to Slide 2 in a PowerPoint 2003, 2007 or 2010 presentation. If you try to create such a link, Word and Excel open the presentation in Normal view, not Slide Show view.

But if you create a Slide Show file and link to that, the hyperlink works; it opens the PowerPoint file in slide show view at the desired slide. A Slide Show is just a PowerPoint file that opens in Slide Show view.

Create a Slide Show

To create a Slide Show file, follow these steps:

  1. Choose File (or Application button)> Save As.
  2. From the Save as Type drop-down list, choose PowerPoint Show (*.ppsx or *.pps).
  3. Specify the location at the top of the dialog box. I recommend that the presentation and the Word or Excel file be in the same folder, in case you need to move the files to another computer; then, the link should continue to work.
  4. Click Save.

Add the hyperlink in Word or Excel

Now you’re ready to create the hyperlink in Word or Excel. Here are the steps:

  1. Open the PowerPoint file and note the slide number to which you want to link. If you want to include the slide title in the hyperlink for your reference, note that too. Close the file.
  2. In Word or Excel, add a hyperlink to some text or a shape by selecting it and choosing Insert> Hyperlink.
  3. In the Insert Hyperlink dialog box, click the Existing File or Web Page button.
  4. Navigate to the PowerPoint Show file and select it. You’ll see it in the dialog box’s Address text box. If there are spaces in the file name, you may see %20 in place of the spaces. %20 is HTML code for a space, so just leave it.
  5. At the end of the file name in the Address box, add a # symbol, then the slide number. An example: sample%20makeovers.ppsx#2
  6. If you want to add the slide title, add a period, space and the slide title. Tip: In the PowerPoint file, you can click the Outline tab in the left-hand pane and copy and paste the slide title from there. My link now looks like this: sample%20makeovers.ppsx#2. Tell ‘n’ showSM
  7. Click OK.
  8. Test your hyperlink. PowerPoint should open in Slide Show view to the slide you specified.

Nice, yes?

Thanks to a reader for asking the question in the older tip that lead to this technique. How will you find it useful?

Share4
Tweet
Share4
+12
Shares 10
READ LATER - DOWNLOAD THIS POST AS PDF >> CLICK HERE <<

Related posts:

  1. Hyperlink to a specific slide in another presentation, or specific location in another file
  2. How to use your remote to switch to another presentation in PowerPoint 2007 & 2010
  3. Insert a live Excel spreadsheet onto a slide
  4. Link to other presentations and return to the original presentation

Filed Under: Hyperlinks Tagged With: Excel, hyperlink, link, PowerPoint 2007, PowerPoint 2010, PowerPont 2003, slide, Word

37
Leave a Reply

avatar
This comment form is under antispam protection
31 Comment threads
6 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
26 Comment authors
mattEllen FinkelsteinTimUdeni ALagiyawaduJMK15 Recent comment authors
avatar
This comment form is under antispam protection
  Subscribe  
newest oldest most voted
Notify of
Sfrancis
Guest
Sfrancis

I tried this both with and without the title, but it still opens to the first slide of the presentation. Any ideas?

Vote Up0Vote Down 
10 years ago
Ellen
Guest
Ellen

I don’t know what might be different in your situation that could cause that. It worked in my tests. Check that there’s no space before the # symbol. I can’t think of anything else.

Vote Up0Vote Down 
10 years ago
Jay
Guest
Jay

I wonder if you can help – I have to use PowerPoint 2003 with excel 2010 ( I know – don’t ask why – its a long story) – I am doing a power point presentation where I need to link an excel 2010 chart to PowerPoint 2003 slide. I manage to create a dynamic link but then when I try to use animation to build chart in powerpoint it does not offer me the chart animation option ie build the data bars one at a time – only basic build. Can you help please.

Vote Up0Vote Down 
10 years ago
Ellen
Guest
Ellen

It would take me too long to try testing this, but here are some ideas:
Insert the chart in PowerPoint using the data from Excel rather than using the Excel chart (in essence, you’re copying and pasting the data from Excel to PowerPoint)
Save the Excel file as an XLS file (2003 format) and try again
Forget about animating the chart itself; instead animate arrows to point to each section as you discuss it

Vote Up0Vote Down 
10 years ago
Maya
Guest
Maya

I managed to get the word document to link to the specific slide in the slide show, however I want to be able to link the word documen to a regular powerpoint slide not a slide show.
Can you advise? Thanks

Vote Up0Vote Down 
10 years ago
Ellen
Guest
Ellen

Do you mean that you want the link to open PowerPoint in Normal view? As I explain in the post, if you link to a PPT or PPTX file, that’s what happens.

Vote Up0Vote Down 
10 years ago
Antares
Guest
Antares

Just checked it because we wanted to link to a specific slide. If the PowerPoint was saved as PPT or PPTX, it opens the Office application and shows the file in edit mode starting from slide 1. But if you saved it as PPS or PPSX and, then the link works starting the slideshow at the given number after #.

Vote Up1Vote Down 
10 years ago
trackback
How to Link a Single PowerPoint Slide to Word or Excel 2007/2010 | BOSS

[…] presentation file for that all important slide or two you want to show your group at this event. Ellen Finkelstein, who writes for the PC Pitstop Newsletter, has a great tip that can help you navigate quickly and […]

Vote Up0Vote Down 
10 years ago
Elliott
Guest
Elliott

Thanks, this works great! Is it possible to the reference link to autoupdate? If the link is attached to slide 2, and the PowerPoint slide moves to slide 4, can the link automatically adjust itself to slide 4?

Vote Up0Vote Down 
10 years ago
Ellen
Guest
Ellen

I don’t think so, but see if you can get the link to work by referring just to the slide title, rather than the number. Then try moving it and see if it still works. Let us know!

Vote Up0Vote Down 
10 years ago
Dr. Debby
Guest
Dr. Debby

This is great info for linking from Word to a specific PPT slide (THANK YOU!), but when I do I get a box that says “Microsoft has identified a potential security concern… Do you want to continue?” Since I’m the one who designed the PPT presentation, I am certain it is safe. Any thoughts about how to stop that from popping up?

Many thanks,Ellen!
Debby Gilden

Vote Up0Vote Down 
10 years ago
Dr. Debby
Guest
Dr. Debby

Here is an update. I found what looked like the answer, but alas, it did not work. As instructed, I cleared the “Check Office documents that are from or link to suspicious Web sites check box,” but still I am getting the security warning. Linking from PPT to Word is a breeze, but linking from Word to PPT always brings up that security warning. Any suggestions?

Vote Up0Vote Down 
10 years ago
Ellen
Guest
Ellen

Debby, go into the Options dialog box (I’m not sure which version you’re using, but click File, then find Options) and look for Trust Center, then Trust Center Settings. Try going through the settings to see if you can lower the security to not get that warning. After you use the presentation, I’d recommend returning them to their former levels, just in case. I don’t know why it happens only in 1 direction.

Vote Up0Vote Down 
10 years ago
Dr. Debby
Guest
Dr. Debby

Hi Ellen,

I finally have a solution. In Word 2010 I went to File > Options > Trust Center > Trust Center Settings > Trusted Locations, then put in the location of the PPT file. Now all works great!

Thanks again for the info on how to link to a specific PPT slide.

Vote Up0Vote Down 
10 years ago
Deano
Guest
Deano

Hi Ellen, I have a problem when trying to link excel worksheets to a powerpoint slide. On my powerpoint slide I have 5 topics which relate to 5 different worksheets in an excel document. I click on a cell in the worksheet I want a hyperlink to, go to my powerpoint, click on the topic which corresponds, click paste as hyperlink and all is well. (The hyperlink address is correct) However when I save and close the powerpoint and then re-open it, the hyperlink address has changed and will now only direct me to the excel document’s first worksheet….. This… Read more »

Vote Up0Vote Down 
10 years ago
Ellen
Guest
Ellen

I don’t know why the end is being stripped out. I’m wondering if the apostrophes are the problem. I’ve never tried linking to a specific worksheet in an Excel document. What happens if the link is to the first worksheet or if there’s only one worksheet?

Vote Up0Vote Down 
10 years ago
Deano
Guest
Deano

If there is only one worksheet then it will work, as it simply opens the document on whatever worksheet you last saved it on.

Likewise you can only link it to the first worksheet if that was the worksheet you were looking at when you last saved the document…

Whats frustrating is the fact that these lniks work perfectly until you close the powerpoint :/

Vote Up0Vote Down 
10 years ago
Ellen Finkelstein
Guest
Ellen Finkelstein

You might do some research on the Microsoft Excel discussion groups about regular HTML hyperlinks to specific worksheets. I discovered the # trick because I knew a little HTML. Maybe someone has worked something out. I just found this, http://www.shaunakelly.com/word/word-and-excel/excelhyperlinks.html, about linking from Word to Excel. It uses a method unique to Word (fields), but one point that was made was enclosing a sheet name with a space in single quotes. If you find something that works, please let us know here!

Vote Up0Vote Down 
10 years ago
Stephen
Guest
Stephen

I have tried multiple ways to have the individual slides link to the excel sheet and every attempt has failed. Any suggestions or walk throughs?

Vote Up0Vote Down 
10 years ago
Steve T.
Guest
Steve T.

Hello Ellen,

This has been very helpful for me. Thank you very much!

All the best,

ST

Vote Up0Vote Down 
10 years ago
Karen
Guest
Karen

When I want to link a specific PPT slide into a Word document, I copy the slide from PPT, Paste Special into Word, and then choose the Paste Link radio button in the Past Special dialog. I leave the default Microsofty PowerPoint Slide object on and click OK. Then, when I need to make edits, I edit in PPT only. When I open Word again, it automatically updates the slides I edited in PPT. Does anyone else do this?

Vote Up0Vote Down 
10 years ago
michael a
Guest
michael a

Yes I just tried your way karen it’s so clever !

Vote Up0Vote Down 
9 years ago
Zdenka
Guest
Zdenka

awesome 🙂 thanks!

Vote Up0Vote Down 
9 years ago
ethan huang
Guest
ethan huang

it is useful,great.Thanks a lot.

Vote Up0Vote Down 
8 years ago
raju
Guest
raju

Thanks for the tips to hyperlink the specific power point slide from excel…
Regards,

Raju

Vote Up0Vote Down 
7 years ago
Jason Nolis
Guest
Jason Nolis

What method do i need to use if i want to show the data in a sheet of an excel in the a powerpoint slide?

Thank you

Vote Up0Vote Down 
7 years ago
colint
Guest
colint

Yes this is a useful thread I got it to work fine when I saved the PP in slide show format…trouble is when you get the animation up it leaves it hanging, if you come out I want it to go back to my word document automatically…oh well I suppose we can’t have everything or can we.

Vote Up0Vote Down 
7 years ago
Mohammad Enamul Bari
Guest
Mohammad Enamul Bari

I want slide reference/ silde number in hyperlink. I know how to do hyperlink but no reference/ slide number shown. I need to do it manually every time. Can anyone help me on this issue

Vote Up0Vote Down 
6 years ago
Baddy
Guest
Baddy

Did this actually work on anyone’s computer?
My friend and I tested on two different computers but every time it starts from the FIRST slide somehow…

Really need a solution!!!

Thank you very much!

Vote Up0Vote Down 
6 years ago
Syed Arshad
Guest
Syed Arshad

Thanks…

Vote Up0Vote Down 
6 years ago
Bk Das
Guest
Bk Das

thanks …
you were a great help

Vote Up0Vote Down 
6 years ago
Mubin Khan
Guest
Mubin Khan

Thanks Ellen, Helpful indeed!

Vote Up0Vote Down 
5 years ago
JMK15
Guest
JMK15

Thanks Ellen, this is just what I needed!

Vote Up0Vote Down 
4 years ago
Udeni ALagiyawadu
Guest
Udeni ALagiyawadu

Thanks. Fine. It is very useful.

Vote Up0Vote Down 
4 years ago
Tim
Guest
Tim

Hello Hellen!

That’s really useful! Is there a way to link to a specific page by using the slide title or some kind of label? If I adjust the order of the presentation or add new pages, I need to update all the #number endings.

Thank you!

Vote Up0Vote Down 
3 years ago
Ellen Finkelstein
Guest
Ellen Finkelstein

Tim, I tried some variations but without the slide number, the hyperlink always opened on slide 1.

Vote Up0Vote Down 
3 years ago
matt
Guest
matt

can i choose specific slides from excel to create a small edited .ppt?

Vote Up0Vote Down 
1 year ago
wpdiscuz   wpDiscuz

Free Video Training!

13 Techniques that Will Make Designing Your Slides EASY!

And get the PowerPoint Tips Newsletter with tips and resources for presenters. Plus 5 bonus tips!

BirdSend Email Marketing Tool
4-up-ads PresenterMedia PoweredTemplate High-Persuasion Secrets Power Pointers Quarter Hour


Recent Posts

Recent Posts

  • How do you format your slide titles?
  • Using PowerPoint’s cartoon people
  • Which version of PowerPoint should you buy?
  • Add a customizable, live web feed with Cameo
  • Get a designer look with abstract images to create backgrounds for slides and shapes

Connect with me!

Connect with me! Twitter LinkedIn Facebook

Ellen Finkelstein, Inc. · Fairfield, IA · Tel: 515-989-1832

Privacy, Refund, and Other Legal Stuff

wpDiscuz