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
|
|||
|
|||
Linking from Powerpoint to a specific Excel worksheet
Hi,
I've got a tough nut to crack. Does anyone know how to create a hyperlink in Powerpoint that will direct the user to a specific worksheet in Excel? For instance, in an Excel file, there could be Worksheet A, Worksheet B and so on. I need to link from Powerpoint to Worksheet B of the Excel file. I'm using Office XP. Thanks a mil! |
#2
|
|||
|
|||
Linking from Powerpoint to a specific Excel worksheet
Hi
in Powerpoint enter the sheet+cell reference with a leading '#' directly after the path+filename. E.g. enter the following as hyperlink D:\Temp\Book1.xls#Sheet3!A1 -- Regards Frank Kabel Frankfurt, Germany Malcolm North wrote: Hi, I've got a tough nut to crack. Does anyone know how to create a hyperlink in Powerpoint that will direct the user to a specific worksheet in Excel? For instance, in an Excel file, there could be Worksheet A, Worksheet B and so on. I need to link from Powerpoint to Worksheet B of the Excel file. I'm using Office XP. Thanks a mil! |
#3
|
|||
|
|||
Linking from Powerpoint to a specific Excel worksheet
as far as I know, you go to Insert Hyperlink, and browse
for the file, and then at the end insert something like this for the specific workbook: C:\...\Blahblahbla.xls!Worksheet2! Try it and see if it works. -----Original Message----- Hi, I've got a tough nut to crack. Does anyone know how to create a hyperlink in Powerpoint that will direct the user to a specific worksheet in Excel? For instance, in an Excel file, there could be Worksheet A, Worksheet B and so on. I need to link from Powerpoint to Worksheet B of the Excel file. I'm using Office XP. Thanks a mil! . |
#4
|
|||
|
|||
Linking from Powerpoint to a specific Excel worksheet
This might help.
http://www.uncc.edu/sysdev/HowTos/Po...entation. htm Judy Freed Systems Development UNC Charlotte wrote in message ... as far as I know, you go to Insert Hyperlink, and browse for the file, and then at the end insert something like this for the specific workbook: C:\...\Blahblahbla.xls!Worksheet2! Try it and see if it works. -----Original Message----- Hi, I've got a tough nut to crack. Does anyone know how to create a hyperlink in Powerpoint that will direct the user to a specific worksheet in Excel? For instance, in an Excel file, there could be Worksheet A, Worksheet B and so on. I need to link from Powerpoint to Worksheet B of the Excel file. I'm using Office XP. Thanks a mil! . |
Thread Tools | |
Display Modes | |
|
|