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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |