Hyperlink Issue


T

txheart

This one isn't an Excel formula question so much as it is somethin
weird that I'd like to figure out and get fixed. Even our compute
network repair guys couldn't figure this one out, so it made me thin
maybe it has something to do with Excel, rather than the computer.

There are 6 computers on our office network. There is an enormou
database with all of the customer information. The Customer name i
column A of that database is hyperlinked to their folder on the networ
-- at everyone else's computer. The hyperlinks don't work for me.

My computer (or is it Excel?) is messing up the dang hyperlinks, makin
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 colum
A. Everyone else on the network can click on the link and it goes wher
it's supposed to go. Mine, however, tosses file:///\\\2003srv\etc...

Anyone know why the extra characters are inserted and how to get rid o
them? I've been opening them the regular way for a year, so it'
obviously not that huge of an issue, but it would be nice to be able t
click on the hyperlink.

Your help is very much appreciated.
~K
 
Ad

Advertisements

J

jaf

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top