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