I need to repair an invalid hyperlink

G

Guest

I'm trying to creat a hyperlink to MS Word and Adobe documents in an
excel spreadsheet. When I click on the hyperlink it says:

"The address of this site is not valid. Check the address and
try again."

When I go to Edit hyperlink in the address box I see the file destination
mixed with numbers and percent signs such as: Corporate/20%Legal/20%

Need help!
 
G

Guest

The % signs are wildcards for filepath names.

What I would do is the following:

1) Make note of the filepath of the Word/Adobe document to which you want to
link.

2) Go to the hyperlink in the XL workbook, delete it.

3) Go to Insert--Hyperlink and navigate to the document, based on the info
you got in step 1. Type in a "friendly name" you want to appear and click
OK. Your hyperlink should work now.

Dave
 

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

Similar Threads

Can UDF return a customized hyperlink? 3
Can you hyperlink to a hyperlink? 1
Excel Macro to hyperlink an archived worksheet to an index page 0
hyperlink function 4
How do I delete a Hyperlink in a cell 2
Hyperlink auto-population? Please Help 1
Hyperlink to cell within a sheet breaks when cells are sorted 1
Hyperlink to the meat of a cell 4

Top