Hyperlink failure after saving document

[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?

 

[Gary''s Student]

Use the HYPERLINK() function:

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


This will protect the integrity of the path.