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
|
|||
|
|||
Hyperlink Issue
This one isn't an Excel formula question so much as it is something weird that I'd like to figure out and get fixed. Even our computer network repair guys couldn't figure this one out, so it made me think maybe it has something to do with Excel, rather than the computer. There are 6 computers on our office network. There is an enormous database with all of the customer information. The Customer name in column A of that database is hyperlinked to their folder on the network -- at everyone else's computer. The hyperlinks don't work for me. My computer (or is it Excel?) is messing up the dang hyperlinks, making them point to a place that doesn't exist. The links all go to 2003srv\users\kylee\Quote Forms\Current Groups\Name of Group in column A. Everyone else on the network can click on the link and it goes where it's supposed to go. Mine, however, tosses file:///\\\2003srv\etc... Anyone know why the extra characters are inserted and how to get rid of them? I've been opening them the regular way for a year, so it's obviously not that huge of an issue, but it would be nice to be able to click on the hyperlink. Your help is very much appreciated. ~Ky -- txheart |
#2
|
|||
|
|||
Hyperlink Issue
Hi,
Check to see if a hyperlink base address has been set in your Excel or the other machines. From Excel help... Set the base address for the hyperlinks in a workbook By default, unspecified paths to hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) destination files are relative to the location of the active workbook. Use this procedure when you want to set a different default path. Each time you create a hyperlink to a file in that location, you'll only have to specify the file name, not the path, in the Insert Hyperlink dialog box. On the File menu, click Properties. Click the Summary tab. In the Hyperlink base box, type the path you want to use. Note You can override the hyperlink base address by using the full, or absolute, address for the hyperlink in the Insert Hyperlink dialog box. John "txheart" wrote in message ... This one isn't an Excel formula question so much as it is something weird that I'd like to figure out and get fixed. Even our computer network repair guys couldn't figure this one out, so it made me think maybe it has something to do with Excel, rather than the computer. There are 6 computers on our office network. There is an enormous database with all of the customer information. The Customer name in column A of that database is hyperlinked to their folder on the network -- at everyone else's computer. The hyperlinks don't work for me. My computer (or is it Excel?) is messing up the dang hyperlinks, making them point to a place that doesn't exist. The links all go to 2003srv\users\kylee\Quote Forms\Current Groups\Name of Group in column A. Everyone else on the network can click on the link and it goes where it's supposed to go. Mine, however, tosses file:///\\\2003srv\etc... Anyone know why the extra characters are inserted and how to get rid of them? I've been opening them the regular way for a year, so it's obviously not that huge of an issue, but it would be nice to be able to click on the hyperlink. Your help is very much appreciated. ~Ky -- txheart |
Thread Tools | |
Display Modes | |
|
|