View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Hyperlink failure after saving document

Use the HYPERLINK() function:

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


This will protect the integrity of the path.
--
Gary''s Student - gsnu200908


"katielou_1" wrote:

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?