Hyperlink failure after saving document

K

katielou_1

I have several hyperlinks in a worksheet to images/pdfs. When I save the
spreadsheet, the hyperlinks fail, with an error that says "the address of
this site is not valid, check address and try again." I am using Excel 2003
with SP3.

When I have created the hyperlinks, they were always to "existing file or
web page."

What can I do to keep the hyperlinks intact?
 
G

Gary''s Student

Use the HYPERLINK() function:

=HYPERLINK("file:///C:\test folder\benefit.pdf","Docs")


This will protect the integrity of the path.
 
Joined
Mar 7, 2013
Messages
4
Reaction score
0
Well aware this is an old thread, but it's one of the first results on Google and the issue occurs in Excel 2010. Comes courtesy of Dave Peterson on a different thread I found once. Tested and this resolves the issue.

In Excel 2003 menus:
File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

In Excel 2007:
Click on the Office button
Choose Prepare, then properties.
Then use the arrow on the Document Properties dropdown
Choose Advanced Properties
And then change the hyperlink base on the Summary tab.

In Excel 2010:
File -> Info -> Show All Properties
Update Hyperlink Base in the list on the right
 

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