hyperlink

G

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.
 
G

Guest

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

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")
 
G

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.
 
D

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.
 

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