hyperlink

[Guest]

I have a spreadsheet that tracks our projects. I've inserted hyperlinks to
the projects. They either link to Excel or Word docs. For some reason they
don't hold the link. When I click on the link, I get a message "no file
found". I've reinserted these links several times and it's getting tiresome.
What am I doing wrong? I don't understand why one day they work, and the
next they don't.

 

[Guest]

Actually, when I click on the link, the message says "cannot open the
specified file."

 

[Dave Peterson]

If you're using Insert|hyperlink, maybe the address of the link is changing.
You may want to make sure you specify a hyperlink base address.

File|Properties|summary tab (near the bottom of the dialog)

I've never had any trouble using the =hyperlink() worksheet formula.

=hyperlink("file:////c:\my documents\word\doc1.doc","Click Me")

 

[Guest]

I think that was it. I did change the base address, not realizing that would
affect the links. I was trying to set the "insert hyperlink" default to a
certain folder, which I have never been able to do yet. Do you have any
advice on that?

Thanks.

 

[Dave Peterson]

Nope.

Sorry.

I think that was it. I did change the base address, not realizing that would
affect the links. I was trying to set the "insert hyperlink" default to a
certain folder, which I have never been able to do yet. Do you have any
advice on that?

Thanks.