Insert a hyperlink to a sheet in an excel workbook

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

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
 
Does this help:

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


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




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
 
I'll give it a try tomorrow at work! I sure hope so.

Thanks!
Linda
Does this help:

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


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




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
 
Back
Top