A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Powerpoint
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Insert a hyperlink to a sheet in an excel workbook



 
 
Thread Tools Display Modes
  #1  
Old November 4th, 2004, 03:07 AM
LMB
external usenet poster
 
Posts: n/a
Default Insert a hyperlink to a sheet in an excel workbook

Hi,

We are using Office 2000. I posted this question on the excel/new users group too since there may be a solution within that program.

We have an excel workbook with our competency check off sheets. Each Sheet is a different competency. Now we are putting education modules together using power point. At the end of the education module on the last slide, we want to have a link to a specific sheet from the excel workbook so the user can print that out to do their competency. I can link to the workbook but it doesn't appear that I can link to a sheet from the workbook. Is there a way to separate all the sheets at once and make them all separate files? I think we want to keep them all in the workbook as well but I know the problems of having two sheets that are identical is not a good idea since you have to update them both.

If you have another solution or know of a way to link to a sheet in a file, I would be grateful.


Thanks,
Linda
  #2  
Old November 4th, 2004, 05:11 AM
Geetesh Bajaj
external usenet poster
 
Posts: n/a
Default

Does this help:

How do I directly refer to a cell within an Excel workbook from a
presentation?
http://officeone.mvps.org/ppttips/re..._workbook.html


--
Geetesh Bajaj, Microsoft PowerPoint MVP
PowerPoint Notes: http://www.indezine.com/notes
Free Templates:
http://www.indezine.com/powerpoint/t...templates.html




"LMB" wrote in message
...
Hi,

We are using Office 2000. I posted this question on the excel/new users
group too since there may be a solution within that program.

We have an excel workbook with our competency check off sheets. Each Sheet
is a different competency. Now we are putting education modules together
using power point. At the end of the education module on the last slide, we
want to have a link to a specific sheet from the excel workbook so the user
can print that out to do their competency. I can link to the workbook but
it doesn't appear that I can link to a sheet from the workbook. Is there a
way to separate all the sheets at once and make them all separate files? I
think we want to keep them all in the workbook as well but I know the
problems of having two sheets that are identical is not a good idea since
you have to update them both.

If you have another solution or know of a way to link to a sheet in a file,
I would be grateful.


Thanks,
Linda


  #3  
Old November 4th, 2004, 06:16 AM
LMB
external usenet poster
 
Posts: n/a
Default

I'll give it a try tomorrow at work! I sure hope so.

Thanks!
Linda
"Geetesh Bajaj" wrote in message ...
Does this help:

How do I directly refer to a cell within an Excel workbook from a
presentation?
http://officeone.mvps.org/ppttips/re..._workbook.html


--
Geetesh Bajaj, Microsoft PowerPoint MVP
PowerPoint Notes: http://www.indezine.com/notes
Free Templates:
http://www.indezine.com/powerpoint/t...templates.html




"LMB" wrote in message
...
Hi,

We are using Office 2000. I posted this question on the excel/new users
group too since there may be a solution within that program.

We have an excel workbook with our competency check off sheets. Each Sheet
is a different competency. Now we are putting education modules together
using power point. At the end of the education module on the last slide, we
want to have a link to a specific sheet from the excel workbook so the user
can print that out to do their competency. I can link to the workbook but
it doesn't appear that I can link to a sheet from the workbook. Is there a
way to separate all the sheets at once and make them all separate files? I
think we want to keep them all in the workbook as well but I know the
problems of having two sheets that are identical is not a good idea since
you have to update them both.

If you have another solution or know of a way to link to a sheet in a file,
I would be grateful.


Thanks,
Linda


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Protecting a sheet or workbook with a pivot table HVAC FOR LIFE General Discussion 1 August 25th, 2004 01:45 PM
Still having Web Page Pathing Problems / Relative Links show Netwo webmaster Powerpoint 27 July 15th, 2004 11:16 PM
Excel 2003 - Using hyperlinks to jump from sheet to sheet Tom General Discussion 2 July 15th, 2004 01:28 AM
Coverting Lotus 123 files to use with excel Muffin1947 General Discussion 6 June 20th, 2004 10:18 AM
Excel 2000 converts UNC links to relative - need to preserve UNC links! Jeff Adams Links and Linking 3 April 15th, 2004 05:46 PM


All times are GMT +1. The time now is 10:32 AM.


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