Hyperlink failure after saving document

  • Thread starter Thread starter katielou_1
  • Start date Start date
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?
 
Use the HYPERLINK() function:

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


This will protect the integrity of the path.
 
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
 
Back
Top