Hyperlinks problems
I've really just started investigating hyperlinks and here is my question, I
hope it's an easy one. Can you set up a hyperlink to open up a specific worksheet in different workbook located on your harddrive/server? I believe it can be done but I'm having trouble with either the syntax of the exact syntax of the location of the specific worksheet or I'm just all out doing it wrong. I've tried using the hyperlink function but I can't seem to get this to work. the link becomes highlighted but will not bring me to the needed sheet. |
Hyperlinks problems
First use:
Insert Hyperlink Existing File or Web Page and then browse Examine the way the Insert formatted the address (URL) part and do the same thing with the HYPERLINK() function. -- Gary's Student gsnu200701 "echo13" wrote: I've really just started investigating hyperlinks and here is my question, I hope it's an easy one. Can you set up a hyperlink to open up a specific worksheet in different workbook located on your harddrive/server? I believe it can be done but I'm having trouble with either the syntax of the exact syntax of the location of the specific worksheet or I'm just all out doing it wrong. I've tried using the hyperlink function but I can't seem to get this to work. the link becomes highlighted but will not bring me to the needed sheet. |
All times are GMT +1. The time now is 04:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com