Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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 | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hyperlink issue | Excel Discussion (Misc queries) | |||
Issue hyperlink in cell | Setting up and Configuration of Excel | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) |