Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default hyperlink in Excel 2007 spreadsheet cell, to a Powerpoint 2007 sli

Without complex visual basic is there any way to hyperlink from an Excel 2007
cell, to slide number [whatever] in a Powerpoint presentation?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default hyperlink in Excel 2007 spreadsheet cell, to a Powerpoint 2007 sli

=HYPERLINK("C:\Documents and Settings\Owner\My Documents\sample.ppt#13")

For the 13th slide

etc.

--
Gary''s Student - gsnu200819
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default hyperlink in Excel 2007 spreadsheet cell, to a Powerpoint 2007

Duh, i never thought of doing it that way! I was thinking inside the box
(highlight a cell's text and click 'insert hyperlink'). It appears that
Gary's student is also a teacher - thanks! :-)

"Gary''s Student" wrote:

=HYPERLINK("C:\Documents and Settings\Owner\My Documents\sample.ppt#13")

For the 13th slide

etc.

--
Gary''s Student - gsnu200819

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default hyperlink in Excel 2007 spreadsheet cell, to a Powerpoint 2007

The suggested hyperlink syntax, when followed precisely, opens up the
powerpoint presentation, but does not display the target slide...it always
just displays the first slide, no matter what slide number is appended after
the "#". Could i be missing something?

"Gary''s Student" wrote:

=HYPERLINK("C:\Documents and Settings\Owner\My Documents\sample.ppt#13")

For the 13th slide

etc.

--
Gary''s Student - gsnu200819

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default hyperlink in Excel 2007 spreadsheet cell, to a Powerpoint 2007

You are correct. I am getting the same behavior in 2007.
2003 works just fine.
--
Gary''s Student - gsnu200819


"Bob W" wrote:

The suggested hyperlink syntax, when followed precisely, opens up the
powerpoint presentation, but does not display the target slide...it always
just displays the first slide, no matter what slide number is appended after
the "#". Could i be missing something?

"Gary''s Student" wrote:

=HYPERLINK("C:\Documents and Settings\Owner\My Documents\sample.ppt#13")

For the 13th slide

etc.

--
Gary''s Student - gsnu200819



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default hyperlink in Excel 2007 spreadsheet cell, to a Powerpoint 2007

I will report this to Microsoft - might be in time for SP2 (I always think
the glass is half-full!)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Gary''s Student" wrote in message
...
You are correct. I am getting the same behavior in 2007.
2003 works just fine.
--
Gary''s Student - gsnu200819


"Bob W" wrote:

The suggested hyperlink syntax, when followed precisely, opens up the
powerpoint presentation, but does not display the target slide...it
always
just displays the first slide, no matter what slide number is appended
after
the "#". Could i be missing something?

"Gary''s Student" wrote:

=HYPERLINK("C:\Documents and Settings\Owner\My
Documents\sample.ppt#13")

For the 13th slide

etc.

--
Gary''s Student - gsnu200819



  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default hyperlink in Excel 2007 spreadsheet cell, to a Powerpoint 2007

Thanks!
--
Gary''s Student - gsnu200819


"Bernard Liengme" wrote:

I will report this to Microsoft - might be in time for SP2 (I always think
the glass is half-full!)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Gary''s Student" wrote in message
...
You are correct. I am getting the same behavior in 2007.
2003 works just fine.
--
Gary''s Student - gsnu200819


"Bob W" wrote:

The suggested hyperlink syntax, when followed precisely, opens up the
powerpoint presentation, but does not display the target slide...it
always
just displays the first slide, no matter what slide number is appended
after
the "#". Could i be missing something?

"Gary''s Student" wrote:

=HYPERLINK("C:\Documents and Settings\Owner\My
Documents\sample.ppt#13")

For the 13th slide

etc.

--
Gary''s Student - gsnu200819




  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default hyperlink in Excel 2007 spreadsheet cell, to a Powerpoint 2007

They replied "This is known PowerPoint bug" !
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Gary''s Student" wrote in message
...
Thanks!
--
Gary''s Student - gsnu200819


"Bernard Liengme" wrote:

I will report this to Microsoft - might be in time for SP2 (I always
think
the glass is half-full!)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Gary''s Student" wrote in
message
...
You are correct. I am getting the same behavior in 2007.
2003 works just fine.
--
Gary''s Student - gsnu200819


"Bob W" wrote:

The suggested hyperlink syntax, when followed precisely, opens up the
powerpoint presentation, but does not display the target slide...it
always
just displays the first slide, no matter what slide number is appended
after
the "#". Could i be missing something?

"Gary''s Student" wrote:

=HYPERLINK("C:\Documents and Settings\Owner\My
Documents\sample.ppt#13")

For the 13th slide

etc.

--
Gary''s Student - gsnu200819






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unlink a chart in Excel/Powerpoint 2007 TimB Charts and Charting in Excel 1 September 13th 08 07:01 PM
Hyperlink from Excel 2007 to a specific slide in PowerPoint Barb M. Excel Worksheet Functions 1 August 21st 08 07:19 PM
Hyperlink an excel spreadsheet to a specific Powerpoint slide Maxine Excel Worksheet Functions 0 July 18th 08 04:01 PM
Linking Excel 2007 to Powerpoint 2007 Russ Links and Linking in Excel 0 June 24th 08 02:14 PM
Chart Selection - Excel 2007 copy to Powerpoint 2007 GS80 Charts and Charting in Excel 1 February 7th 08 01:30 PM


All times are GMT +1. The time now is 08:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"